Forum Discussion
Help Calculating Previous Fiscal Year Sales
Greetings All - I need to calculate previous fiscal year to date sales data by sales category based on our our fiscal year. It starts September 1st, ends August 31st. I have my sales table relat...
That measure doesn't throw any errors, but it still doesn't provide the correct values for the fiscal YTD sales for FY22. I get the exact same values that are too low that I showed above. Having a hard time understanding why a calculation that should be relatively straightforward is proving so difficult to do in PBI. Is there some row level context I'm missing in my DAX?
Hi,
Was this resolved in the end?
Thanks