Forum Discussion
modeling for agregation
Hi,
I am having the following issue.
I have a master table with several dates and I need to agregate the information by 3 differents dates, I have created 3 dates tables and linked each table with each date, at top level I have added other date table to control(Filter) the 3 dates that should agregated the indormation.
I want to avoid duplicated my master table since have a huge volume.
all the infomation should be aggregated by 3 dates and added into a single visual.
could you provide any guideliness? Thanks
Konios , You can use inactive joins and userelationship to activate the measure.
Join will all the dates, you will have inactive joins
example
calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))
Refer
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
2 Replies
Konios , You can use inactive joins and userelationship to activate the measure.
Join will all the dates, you will have inactive joins
example
calculate( SUM(Sales[Sales Amount]),USERELATIONSHIP ('Sales'[CreateDate], 'Date'[Date]))
Refer
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUThanks, it works well.
Great solution.
Cheers
