Forum Discussion

S_M's avatar
S_M
Icon for Helper III rankHelper III
8 years ago

Dynamic monthly budget calculation based on dates selected

Hi,    I am facing some troubles putting together a measure that would dynamically calculate budgets based on a date filter selected. For context, i have a budget table that looks like :  ...
Need Help
S_M's avatar
S_M
Icon for Helper III rankHelper III
8 years ago

Thanks v-yulgu-msft, im going to give that a try. 

 

Also, in order to create a relationship between the date table and the budget table, i created an intermediate 'filter table', which has only a single column - distinct values for 'month'. I then related the filter table with the date and the budget tables, creating an indirect relationship between budget and date tables, that works in 'both' directions, and voila :) 

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi S_M,

 

Have you worked it out? If yes, please kindly mark the helpful reply as an answer. If you still have any concern, please feel free to ask.

 

Regards,
Yuliana Gu