Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Table

Hi, I need help creating a calculated table. Here is the scenario -   The requirement is to create a calculated table based the columns from 2 tables based on selection for the latest date from the...
General Comment
Need Help
Tutorial Requests
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your further description, i create a seperate date slicer table:

    Then try this measure:

    Measure = IF(MAXX(ALL('Table 1'),'Table 1'[date])<>SELECTEDVALUE('Date Slicer'[Date]),IF(MAX('Table 1'[date])=MAX('Table 2'[Date]),1,0),IF(MAX('Table 1'[date])=SELECTEDVALUE('Date Slicer'[Date]),1,0))

    Apply this measure to the table1, when you choose the max date in table1, it shows the max date's data:

    When you choose other date which is not equal to the max date in table1, it shows the data with table1[date]=table2[date]:

    Here is my test pbix file:

    pbix 

    Expect your reply!

     

    Best Regards,

    Giotto Zhi

     

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to create this measure:

Measure = IF(MAX('Table 1'[date])=MAX('Table 2'[date]),1,0)

Then apply it to the table1 visual, the result shows:

Or if you want to generate a new table, please try this:

Table = FILTER(SELECTCOLUMNS('Table 1',"country",'Table 1'[country],"rate",'Table 1'[rate],"date",'Table 1'[date]),[Measure]=1)

The result shows:

Tips: All above two ways do not need to create any relationship among tables.

Here is my test pbix file:

pbix 

Hope this can help.

 

Best Regards,

Giotto Zhi