topic Re: DAX formula filtered by Selected Value Slicer ? in DAX Commands and Tips

DAX formula filtered by Selected Value Slicer ?

Anonymous — Mon, 06 May 2024 01:29:04 GMT

Hi there,

I have created the below measure which is calculating previous forecast and is directing to my previous report indexed as -1 in RelativeMonth. However, I now want to be able to go back to any previous report and not only the most recent indexed as -1.

Is it possible to add a slicer for "ReportingMonth" and update my measure to calculate based on the "ReportingMonth" Selected?

new forecast previous measure = CALCULATE(

SUM('3503 Working Data'[Month Value]),

'3503 Working Data'[Baseline / Forecast]="Forecast",

'3503 Working Data'[RelativeMonth]=-1)

Re: DAX formula filtered by Selected Value Slicer ?

Jihwan_Kim — Mon, 06 May 2024 02:50:00 GMT

Hi,

I am not sure how your semantic model looks like, but if you have a sort order column for ReportingMonth, please try something like below whether it suits your requirement.

new forecast previous measure = CALCULATE ( SUM ( '3503 Working Data'[Month Value] ), '3503 Working Data'[Baseline / Forecast] = "Forecast", OFFSET ( -1, ALL ( '3503 Working Data'[ReportingMonth], '3503 Working Data'[ReportingMonthSortOrder] ), ORDERBY ( '3503 Working Data'[ReportingMonthSortOrder], ASC ) ) )

Re: DAX formula filtered by Selected Value Slicer ?

Anonymous — Fri, 10 May 2024 05:18:00 GMT

Hi Anonymous ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng