Display last 3/6/12 months Sales/values using measure in PowerBI | MiTutorials

Display last 3/6/12 months Sales/values using measure in PowerBI | MiTutorials
Create a measure to show last 3 months or 6 months sales!

[@damienhickey2600]

I've been searching all morning on how to do this. Thank you so much! Subbed!

[@mrbilbao01]

Thank you. Great tutorial. How would you make it dinamic though?

[@syedaneesdurez8766]

Amazing video

[@Ramesh00300]

can we use dateadd function here ? with interval as -3, month ?

[@adambrown8008]

Instead of the previous 3 (when using the MAX date) - How would you sum e.g. July August & September in your example...but still using the MAX function? Thank you. Nicely explained video :)

[@julianomanji]

Will it work if I select a month different than the last available month?

[@Mahesh717]

🙋 for the last 3 month, from where did the function take the 3 months values, does it taken from december or from january ?

[@sumukh2298]

Thank you

[@azizquazi]

Can we do dynamic - 3 months / 6 months etc. Hope for another video here...Thanks in advance

[@pramuditoanggara739]

It works!

[@sudhakarreddy9780]

we didn't get where you bring test dataset

[@samuna8950]

Can we make slicer of last 3 months and last 6 months?

[@shubhamkupade9947]

suppose date given from 1 jan 2019 end with 12 dec 2020 at that time same dax is useful or not

[@MITutorials]

Yes you can use the same dax

[@maniarasan10]

Am using same but getting current month and last2 month

[@MITutorials]

You must be missing some step.. please see the steps carefully in the video.

[@gagansingh3481]

Awesome video recently subscribe you ...Many cool tricks keep on uploading videos with real time problems ...