FY YTD DAX Help

[Anonymous]

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

[ribisht17]

@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