Forum Discussion
YTD Calculation without Date Field
Hi Rustin788
Can you describe your "fiscal calendar that puts days in different months" ?
Can you share your date table?
Hey,
It is a 5,4,4 fiscal calendar, so January has 5 full weeks, Feb has 4 full weeks, etc. The first day of 2024 is actually 1/31/23 in what we are using.
At the moment, someone else is adding that in before I get the data so I have a text field fical month & year. (We aren't allowed ODBC to get this data) However, I do have the start of a calendar in PowerBI that I am hoping to use.
Here is a small fake sample of the data as well as the calendar table I'm setting up.
https://docs.google.com/spreadsheets/d/1W0p73pIW-ppt1pFlRv5K6nI1Ll_kS1QB-4fejOkalB0/edit?usp=sharing
Hi Rustin788
Does this match your Fiscal calendar?
I just want to make sure before I start writing the DAX script. (Maybe in Power Query later.)
Yes, that appears to be it.