Forum Discussion
Dynamic YTD Formula (DAX)
Hi,
PBI file attached.
Hope this helps.
Upload it to Google Docs and share the download link. Please also answer the questions asked in my earlier message.
Here you go. The google doc has additional fields. and yes FY months are July-June
https://docs.google.com/spreadsheets/d/1ACn_70cU0GS1_FO-FAt8LFdDLfbz4TsWfYyYOAWpUJM/edit?usp=sharing
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.
Hi,
PBI file attached.
Hope this helps.