Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Comparing two values in two visual

Currently I have two different matrix one which has current month data and one with previous month data (the months r not actual month dates but business month date logic attached as image). I want t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I was able to do this calculation using the given measure hope it helps out someone in the future 

     

    Please note I added this measure into the Current Month matrix and the measure calculation  is based on that .

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Usually in such cases either on the period start date or with YYYYPP we create a rank and try to create this month vs last month

 

With a separate year period table say Date

 

new column

Period Rank = RANKX(all('Period'),'Period'[year period],,ASC,Dense)

 

measures

This Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Period'),'Period'[Period Rank]=max('Period'[Period Rank])))
Last Period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Period'),'Period'[Period Rank]=max('Period'[Period Rank])-1))

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak Thank you for your response . I already have index columns created in current month and prev month table(both are of 2021) using RANKX function can that be used somehow as index 1 in both the tables are the ones to be compared(similary each index) . Also could you  plz provide some more insight on this year table concept I couldnt quite grasp it.