cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SpokingAround
Regular Visitor

How do you combine two running totals in a Dax measure?

Hi,

 

This my first post, so please bear with me... I have tried to give as much info as possible but it is commercially sensitive data so am unable to share the file itself.

I have two tables of records. Each table has a recordID column of unique values, that I use to count the number of distinct records. I have successfully created two running totals.

However, I now wish to combine them, and am completely stumped on how to handle the scenario where one of the running totals has no new data for a given date.

SpokingAround_0-1634289448582.png

 

I have read multiple blogs on this, which conclude that linking to a central date table was the answer along with using the USERELATIONSHIP function. I believe I have this set up correctly.

SpokingAround_1-1634289518004.png


SpokingAround_2-1634289569249.png

SpokingAround_3-1634289591752.png
I am pulling my hair out on the issue... Where am I going wrong?

Thanks

 

SpokingAround

 

1 REPLY 1
lbendlin
Super User
Super User

You will want to include a calendar table in your data model, and then use the date column from that calendar table as your base for the calculation of the measures.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors