Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
@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-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Thanks, it works well.
Great solution.
Cheers
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |