Forum Discussion
Budget Cost Table
Hi everyone, A new Power BI user around here .... i would like to make a question about how to make a budget table wich specific months. Every month I receive an excel file with a Cost budget FY th...
mahoneypat
Microsoft Employee
Microsoft EmployeeSounds like you have two date columns (Month Budgeted and Month of the Budget). Assuming you have a Date table, you could have two relationships, one to each of these columns. One would be inactive, but you could write measures with USERELATIONSHIP() to activate it. In the same DAX expression you could then calculate the amount in one column as a function one or more of the values of the other, and visualize it all.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat