FY sales dax help

[Anonymous]

Hi experts,

Need to calculate fInancial year sales (starting from april) based on the end date or year-month selected by the user.

Please help

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Anonymous]

@Ashish_Mathur Please refer below pbix file

https://drive.google.com/file/d/1flF3jg4ZFqZM_wAjYhQVcoB3OQH0p0jf/view?usp=sharing

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Fowmy]

@Anonymous 

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 )
)

[Anonymous]

Hi, Need to calculate fInancial year sales (starting from april) based on the end date or year-month selected by the user.

[ALLUREAN]

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