Forum Discussion

Salman_99's avatar
Salman_99
Frequent Visitor
2 years ago
Solved

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  Dat...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Salman_99
    Frequent Visitor
    2 years ago

    Yes, thank you so much