Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Konios
Regular Visitor

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. PBI S.PNG

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.