Solved: Total for selected period vs last N years

Mmanou · ‎08-21-2022

Hello

for the selected current period I want to compar the total sales between curent pereiod and last 4 years

this is what I want to see if I select the period from slicer betrween 01/08 and 21/08 for last

thank you for your help

Jihwan_Kim · ‎08-21-2022

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

I suggest having a disconnected slicer table like below.

All measures are in the attached pbix file.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

View solution in original post

Jihwan_Kim · ‎08-21-2022

Hi,

Please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

I suggest having a disconnected slicer table like below.

All measures are in the attached pbix file.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Mmanou · ‎08-24-2022

Thank you Jihwan, its works perfectly for me

Fowmy · ‎08-21-2022

@Mmanou

This video from sqlbi.com should work for you, modify as per your requirment:
https://youtu.be/d8Rm7dwM6gc

Did I answer your question? Mark my post as a solution! and hit thumbs up

Total for selected period vs last N years