Forum Discussion
Power bi formula
Hi Team
I have this data in Table 1 such as
Date Overall Score Overall count
01/11/23 65% 1
And in table 2 similiarly
Date Overall Score Overall Count
01/12/23 67% 2
I need one formula to create a bar and line chart date wise
I tried with some formulas but it is not helping me
Hi, Salman_99
Firstly, you can create a calculated table as follows. This puts all the data from both tables in the new table.
Date = CALENDAR(MIN('Table'[Date]),MAX('Table (2)'[Date]))Then you need to create relationships for the three tables based on date.
Here's a visual example of my test data.
Is this the result you expect?
Best Regards,
Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Salman_99 Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi, Salman_99
Firstly, you can create a calculated table as follows. This puts all the data from both tables in the new table.
Date = CALENDAR(MIN('Table'[Date]),MAX('Table (2)'[Date]))Then you need to create relationships for the three tables based on date.
Here's a visual example of my test data.
Is this the result you expect?
Best Regards,
Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, thank you so much
