Power bi formula

[Salman_99]

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

[Anonymous · Accepted solution]

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.

[Salman_99]

Yes, thank you so much 

[parry2k]

@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/38490