Forum Discussion
Solved
Dynamic YTD Formula (DAX)
I have two tables, budget and sales. I want to create a dynamic ytd budget formula that only sums the data through the max month in the sales table. I already converted the month name to numbers. ...
Hi,
PBI file attached.
Hope this helps.
OK, but the sales tab is an aggregate of the month. Also, the budget tab is the budget for the month because there is no daily budget. I suppose I can create a date field with the same day of the month if you believe that will work?
Do not bother about creating a Date column - i will create that. I just need 2 columns in each table - Year and Month name.
OK I just added the year column. Month was already in the file