Forum Discussion
YTD Calculation without Date Field
Hey, I'm trying to figure out the best way to have YTD calculations in data that is using a fiscal calendar that puts days in different months. My dataset (SalesData) has a Fiscal-Month field as wel...
Hi Rustin788
You can use one trick here
You have the Year and month, you can create a Calculated column for the Date
The date will be the Start date or end date of the month example if the month is Jan show date should be 1.1.Year or 31.1.Year
Then you can use the date column for YTD calculation
If this trick works for you, keep posted