Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Creating a data model which changes the join condition between two tables based on filters

Hello All Problem: The user can select two period, say 202307 (comparative period) and 202310 (current period), I need to compute for that between the two periods: List Price Band growth: [ List Pr...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    HI Anonymous ,

     

    For this you need to create a disconnected table for the filtering of the date period you want to compare and then making a measure that allows to get that specific value for the specific time.

     

    Something similar to:

    Previous Period = CALCULATE (SUM(Table[Column]), Table[Date] = SELECTEDVALUE(DisconnetedTable[Date]))

    Depending on the calculations you need you can then use this measure to make differences and variations and cumulatives.

MFelix's avatar
MFelix
Super User
2 years ago

Hi Anonymous ,

 

Create a dimension table for periods and related both tables based on that table with one to many relationship this will allow for the filtering and comparision.