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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sergiorodrigues
Frequent Visitor

DAX script to relate two separate fact tables with 1-* relashionship to the dimension table

Let's say I have the model below. A Car table, a table with all gas consumed by each car in the company and another table with car status for each date. I know the "Status" column should be modeled in the table with the gas data but it is what it is. 

sergiorodrigues_0-1615251017240.png

I'd like to generate a table using DAX with total gas consumed by each car in each status and grouped by month/year like below:

Month/YearCarStatus1Status2Status3
Jan/2020A10137
Feb/2020A12913
Jan/2020B1578
Feb/2020B47045

 

Any suggestions?

1 REPLY 1
amitchandak
Super User
Super User

@sergiorodrigues , You need to have common status and Date table too

 

how to get a common table in DAX -https://www.youtube.com/watch?v=Bkf35Roman8

 

power query

https://www.youtube.com/watch?v=kU2M1LmNvNo

https://www.youtube.com/watch?v=vHuhbvYCiNc

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors