Hi,
I am relatively new to PowerBi and I have been looking to practice on some example data.
My aim is to count the number of rows in my dataset (Based on number of fires and there is 1 fire per row) in the current financial year to date and the same time in the previous financial year (FY runs from 1/4 to 31/3).
I have come across a previous chat which I have replicated the solution from in my own dataset successfully. However this was designed for calendar year and I would like to ammend it for financial year.
Any help on how to do this based on the below DAX would be greatly appreciated.
Total Sales =
CALCULATE(SUM(Data[Sales]))
YTD prods =
CALCULATE (
[Total Sales],
FILTER (
'Calendar',
'Calendar'[Year] = YEAR ( TODAY () )
&& 'Calendar'[Date] <= TODAY ()
)
)
LY YTD Sales =
CALCULATE (
[Total Sales],
FILTER (
'Calendar',
'Calendar'[Year]
= YEAR ( TODAY () ) - 1
&& 'Calendar'[Date]
<= EOMONTH ( TODAY (), -13 ) + DAY ( TODAY () )
)
)
Difference% =
DIVIDE([YTD prods] - [LY YTD Sales],[LY YTD Sales])
