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.
Hello my dear Power BI Community,
At the moment I have been spending a lot of time to solve the following problem and so I decided to go for help.
Considering that I am still quite new to Power BI, it can be easy for you to solve the problem - but would do me a huge favor.
Now let me describe the problem in more detail:
I use the following two tables from different information sources:
The aim is to compare the sum of the two tables calculated on the day.
The calculated measure as sum per day is correct for both tables as shown in the figure below.
If I pack this information into one table, then the total sum is displayed as you can see in the next figure (here for transmissions).
Do you know what I'm doing wrong. Sure, the source of the problem is the date, which is listed separately in both tables, but how can this information be summarized?
Thank you very much for your contribution.
qwertzuiop
Solved! Go to Solution.
Hi @qwertzuiop
What you are missing is a data dimension/calendar table, please see the article below for the version of it.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Once you have this table in your model you create a relationship between date dimension and other tables using dates like below.
Later use date from your date dimension/calendar table in your visuals.
Hi @qwertzuiop
What you are missing is a data dimension/calendar table, please see the article below for the version of it.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Once you have this table in your model you create a relationship between date dimension and other tables using dates like below.
Later use date from your date dimension/calendar table in your visuals.
@qwertzuiop Please create calculated column
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |