Forum Discussion
Dynamic YTD Formula (DAX)
Hi,
PBI file attached.
Hope this helps.
There should also be an year column in there. I cannot take the year from FY2024 because this FY will also include months from the previous CY. So have a year column as well.
I think that is fine because the budget tab will always only have one Fiscal Year and no previous years
That isn't the point. I will need that column in order to create a Date field. This in turn will allow me to create a Calendar table.
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.