Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Calculate last 12 months from Selected Month from Slicer

Hi Experts

 

See attached Sample File

I am trying to dynamically calculate the last 12 months from the selcted month on the slicer. 

 

Sample Data
https://www.dropbox.com/s/va9t5wrkxxjjpls/v1.3.pbix?dl=0 

2 ACCEPTED SOLUTIONS
niteshtrehan89
Helper III
Helper III

Hi

Can you please try the below dax function

 

Sales =

VAR CurrentDate = SELECTEDVALUE(‘Date'[End of Month Date],MAX(‘Date'[End of Month Date]))

VAR PreviousDate = CurrentDate – 365

RETURN

CALCULATE(

    SUM(Table[SalesAmount]),

    FILTER(

        Table,

        Table[End of Month Date] >= PreviousDate && Table[End of Month Date] <= CurrentDate

    )

)

View solution in original post

Anonymous
Not applicable

Hi Nitesh. The measure is not working, can you kinldy test uing the Sample file.

View solution in original post

2 REPLIES 2
niteshtrehan89
Helper III
Helper III

Hi

Can you please try the below dax function

 

Sales =

VAR CurrentDate = SELECTEDVALUE(‘Date'[End of Month Date],MAX(‘Date'[End of Month Date]))

VAR PreviousDate = CurrentDate – 365

RETURN

CALCULATE(

    SUM(Table[SalesAmount]),

    FILTER(

        Table,

        Table[End of Month Date] >= PreviousDate && Table[End of Month Date] <= CurrentDate

    )

)

Anonymous
Not applicable

Hi Nitesh. The measure is not working, can you kinldy test uing the Sample file.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.