Skip to content

dax

Power BI – split budget into ratios via DAX

  • ilyar126 

In certain times, you would like to split a higher grain number into lower grain by using some percentage ratios. For example, if you have a budget for Product Brand all up, we want to split further the budget into Product Names based on last year’s sales percentage ratios. You can do this by: Procedure steps to split budget categories First, we have the high-level budget figures for the next… Read More »Power BI – split budget into ratios via DAX