modeling for agregation

[Konios]

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

[amitchandak · Accepted 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]

Thanks, it works well.

Great solution.

Cheers