Forum Discussion
Use one path or another between tables depending on a SELECTEDVALUE
Hi Anonymous,
Althought I used a slight different path (putting both files on the same directory, then get data by folder, then appending both files and using the file name to add the year), the result was the same as yours, but yes, I like your way too!
Thx,
Ben
HI Anonymous,
I don't think you can dynamic control active relationship based on slicer.
In my opinion, if there tables has similar structure, you can use union function to merge 'Locations 17' and 'Locations 18' tables and add year tag, then build relationships between merge table and dim tables(region,division,year).
After these steps, you can simply use year to filter on project table.
Sample:
merged =
UNION (
ADDCOLUMNS ( 'Locations 17', "Year", 2017 ),
ADDCOLUMNS ( 'Locations 18', "Year", 2018 )
)
Regards,
Xiaoxin Sheng
Hi Anonymous,
Althought I used a slight different path (putting both files on the same directory, then get data by folder, then appending both files and using the file name to add the year), the result was the same as yours, but yes, I like your way too!
Thx,
Ben