topic Re: Immediately Prior focus period measure in DAX Commands and Tips

Immediately Prior focus period measure

Bhanuaripaka — Mon, 20 May 2024 07:02:42 GMT

Hi all,

I am trying create a sum of sales prior period dax measure based on current slicer date range selction.

for eg: my Slicer date range is April 20 - 7 may, days between this date range is 17 , I want a measure which goes 17 days behind from start date (April 20 ). I.e; April 3rd to 19 April

it should display some thing like this

Really appreiate your help. Thank you!

Re: Immediately Prior focus period measure

xifeng_L — Mon, 20 May 2024 07:32:59 GMT

Hi Bhanuaripaka ,

You can refer to below demo.

Demo - Immediately Prior focus period measure.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Re: Immediately Prior focus period measure

Bhanuaripaka — Tue, 21 May 2024 06:25:40 GMT

It worked, thanks much for your help.

Re: Immediately Prior focus period measure

Bhanuaripaka — Thu, 23 May 2024 05:40:38 GMT

Hi. Just wanted to check wheather is there way to build a immediate prior period logic which overlay on current period selection ?

Currently it shows like this

is there way can we do like below ?

Appreciate your thoughts.

Re: Immediately Prior focus period measure

xifeng_L — Fri, 24 May 2024 08:36:45 GMT

Bhanuaripaka

You can refer to below measure.

Measure = VAR CurDate = MAX('Date'[Date]) VAR Slicer_Start = CALCULATE(MIN('Date'[Date]),ALLSELECTED()) VAR Slicer_End = CALCULATE(MAX('Date'[Date]),ALLSELECTED()) VAR N = Slicer_End-Slicer_Start RETURN CALCULATE( SUM('Sales'[Quantity]), 'Date'[Date]=CurDate-N-1 )

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Re: Immediately Prior focus period measure

Bhanuaripaka — Fri, 24 May 2024 10:40:49 GMT

Perfect,Thank you so much.

Re: Immediately Prior focus period measure

Bhanuaripaka — Sat, 25 May 2024 09:40:41 GMT

Hi again. Measure is working exactly as expected but total is incorrect, can you please help me to fix it. Total of Measure should be 563 but it was showing 139.

I have tried using SUMX and SUMMARIZE but not luck.

Thanks for you time.

Re: Immediately Prior focus period measure

xifeng_L — Sat, 25 May 2024 10:10:46 GMT

Bhanuaripaka

You can refer to it.

Measure = VAR Slicer_Start = CALCULATE(MIN('Date'[Date]),ALLSELECTED()) VAR Slicer_End = CALCULATE(MAX('Date'[Date]),ALLSELECTED()) VAR N = Slicer_End-Slicer_Start RETURN SUMX( VALUES('Date'[Date]), // Use the Row label Field of Matrix VAR CurDate = 'Date'[Date] RETURN CALCULATE( SUM('Sales'[Quantity]), 'Date'[Date]=CurDate-N-1, ALL ('Time Granularity Table') ) )

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Re: Immediately Prior focus period measure

Bhanuaripaka — Sat, 25 May 2024 10:21:53 GMT

Many thanks again.