Forum Discussion
Measure with relationship between two dimension tables
Super UserAnonymous , I think better you filter accounting slicer as per need from date table, and join both with fact , that should solve purpose
How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8
or use treatas create a measure in accounting period table to filter it from date table and use it as visual level filter
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
to clarify, I would like to be able to achieve this in Power BI
I would like the same measure to aggregate the daily total in the context of either the ReportingDateEnd or MonthEnd
what should the measure look like?
what should the relationships between fact and the two dimension tables look like?
the fact table has relationship to DIM_Date using Date_Key and to DIM_AccountingPeriod via TimeID. how can I get both the Date from DIM_date to work with either DIM_AccountingPeriod in the same visual?
hi amitchandak
Just checking if you have anything further to add after my response?