Forum Discussion

SG2015's avatar
SG2015
Frequent Visitor
4 years ago

Pass visual-date-filter as parameter for measure based on different date-table

Hi all I hope you guys can help me out here…   How can I pass the date-value in the visual-filter as a parameter for the calculation of a time-series measure that is based on a different date tabl...
Need Help
Show and Tell
SG2015's avatar
SG2015
Frequent Visitor
4 years ago

No, I  tried with USERELATIONSHIP-Function. That didn't work. I think the reason is, that 

with my fact-table it is not like the "usual" examples where you have an order-date and shipping date and join same date-table on both dates resulting in one active and inactive relationship. 

 

As I mentioned before: I have a fact-table in which each record is saved every month again at the end of the month. This results, that there are up to 14 rows of the same record - each with a different eom-date. Therefore I have to have a date-table for just filtering on the snapshot-date and then do all the magic time-series-stuff to calculate the measures on a 2nd date-table. but here behaviour is not as expected. 

 

I will provide a pbix-test-file, so you can understand the data (simplified) and model.