Select any 2 periods using filter to compare its sales amount differences

[Anonymous]

Hi, 

I currently run monthly sales plan sheet and readers want to select 2 period to see the differences.

e.g.

currently month vs last month

January vs March

April vs August

etc

So the feature I would like to develop is, 

there's selection filter to choose any 2 period then measure can calculate the gap. 

for this, how can I create the filter and measures? so that I can put the measure into table next to each Quarter column to see the gap. 

[Ashish_Mathur]

Hi,

That data is not well structured.  Using the Query Editor, we will first have to transform the data insto a structure that makes the data amenable to slicing/filtering.

[lbendlin]

Put your periods into a slicer.  Then force the user to select exactly two items (via FILTERS()  - your users will love that!)  and then in your measure grab the MIN and MAX values of that column, and structure your measure accordingly.

[Anonymous]

Thanks for the guidance, can you help me draw the measure?