Doubt regarding calcuation w.r.to Lag

[Likhitha]

Hello All,

I'm having lag column w.r.to month which means if lag is 1 and current month selection is November then my lag month is October,if it is lag 2 then lag month is september...the logic is like this.

And I'm having sales(%) for all months and if I select any lag and month(ex:october month and lag 2)

On graph i want to project lag month (August month sales (%)) on graph

How to achieve this??(Lag selection is dynamic)

[v-xuding-msft · Accepted solution]

Hi @Likhitha ,

I created a sample. Please try and check if it is what you want.

• Create a measure

Measure = 
var a = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Month] = MONTH(TODAY()) - 'Lag'[Lag selection]))
return
IF(ISFILTERED('Lag'[Lag]),a,SUM('Table'[Sales]))

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.