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.

lbendlin's avatar
lbendlin
Super User
2 years ago

2. There is no need for separate tables. All you need is a column that identifies the snapshot.