Forum Discussion

Bastienlin_'s avatar
Bastienlin_
Icon for Helper II rankHelper II
4 years ago

Dynamical dimension table

Hello, I have an issue where my dimension table is changing over the years. What I tried to do to deal with it, is to add a date to all my tables so that I can filter the right lines in my dimensi...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Bastienlin_ ,

 

Please firstly make the relationship between Price table and Ref_Date table inactive:

Then create a flag measure:

Flag = 
var _t=SUMMARIZE(FILTER(ALL('Ref_Company'),[Date]=SELECTEDVALUE('Ref_Date'[Date])),[Index])
return IF(MAX('Price'[Index]) in _t && MAX('Price'[Date])=SELECTEDVALUE(Ref_Date[Date])   ,1,0)

And apply it to visual-filter pane, set as "is 1" as shown below:

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.