Forum Discussion

sandy_PBI's avatar
sandy_PBI
Frequent Visitor
2 years ago
Solved

Snapshot Comparison based on dynamic date selection

Hello, I am trying to build a logic to build a table which compares 5 meaures for user selected snapshot data. currently i am only provided a table which compares the latest snapshot and previous s...
Need Help
Tips and Tricks
  • sandy_PBI's avatar
    sandy_PBI
    2 years ago

    just an update how i solved this : 

     

    i created 2 tables for dates in SQL DB, uploaded them as independent tables and linked to the main table (which contained the meaures) using SELECTEDVALUE.

     

    thanks all for inputs.

sandy_PBI's avatar
sandy_PBI
Frequent Visitor
2 years ago

thanks AnalyticsWIzard for a details explanation. 

I followed your steps but am getting a boolean output.

MRP_WATERFALL[TOTAL_DEMAND_M] is the expressesion 

LAGWEEK is the snapshot table.

TOTAL_DEMAND_SELECTED = CALCULATE(

                             MRP_WATERFALL[TOTAL_DEMAND_M],
                                                         FILTER(ALL(MRP_WATERFALL[LAGWEEK]),MRP_WATERFALL[LAGWEEK])) = SELECTEDVALUE(MRP_WATERFALL[LAGWEEK])
 
I am trying to leverage the same table LAGWEEK which is currently used a filter instead of creating a new table. 
 
Is that the reason why my output is a boolean? 
Secondly is there a way that i can leverage the same table LAGWEEK instead of creating of creating another one?
 
Best Rgds. 
sandy_PBI's avatar
sandy_PBI
Frequent Visitor
2 years ago

just an update how i solved this : 

 

i created 2 tables for dates in SQL DB, uploaded them as independent tables and linked to the main table (which contained the meaures) using SELECTEDVALUE.

 

thanks all for inputs.