Forum Discussion
FY sales dax help
Super UserAnonymous
Not enough information to understand your requirements, If you need the past 12 months sales then this measure should work for you.
FY Sales =
CALCULATE(
[Total Sales],
DATESINPERIOD( 'dates'[Date] , -1 , YEAR )
)Hi, Need to calculate fInancial year sales (starting from april) based on the end date or year-month selected by the user.
- ALLUREAN
Solution Sage
Hi, Anonymous
You can check this article https://allure-analytics.com/index.php/2022/05/14/standard-calendar-date-table-in-power-bi/
In your case you can use the code in ULTIMATE DYNAMIC DAX CALENDAR + FISCAL PERIODS
and change _startOfFiscalYear to 4 and use it as a slicer. You need to connect it to your sales table by Date.
Also, if you need to calculate Fiscal YTD just check this:
https://allure-analytics.com/index.php/2022/05/24/time-intelligence-in-power-bi/
or simply:
FiscalYTD = CALCULATE([Sales], DATESYTD('Date'[Date], "03/31") --where 03/31 is end date and fiscal year start on 1st April
