Forum Discussion
FY YTD DAX Help
Hello experts,
Based on the financial year selection, I want to calculate complete last financial year sales.
Please help
SALE YTD CY =
TOTALYTD(SUM(Sales[Amount]),'Calendar'[Date], ALL('Calendar'), "6/30")
SALE YTD PY =
CALCULATE (
TOTALYTD (
SUM ( Sales[Amount] ),
'Calendar'[Date],
ALL ( 'Calendar' ),
"6/30"
),
SAMEPERIODLASTYEAR ( 'Calendar'[Date] )
)
Please check my pbix file
https://drive.google.com/file/d/1BGdZIExVWml76P2cQ8GJf8L_AFBscISr/view?usp=sharing
1 Reply
- ribisht17
Super User
Anonymous
Please check https://community.powerbi.com/t5/Desktop/FY-sales-dax-help/m-p/2545163
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series
