Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
I am pulling my hair out on the issue... Where am I going wrong?
Thanks
SpokingAround
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |