Forum Discussion

e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
7 years ago
Solved

How apply filter in 2 different dimension tables

Hi ,   I have 2 tables, first table has "time", "A", "B", "C", "D" 4 columns. use time as filter. Now I need to create a new table. New table column is based on ABCD calculation as below:       ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    e2liu77,

     

    See code below.

    IF (
    MAX ( table2[column1] ) =
e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
7 years ago

Hi v-chuncz-msft,

 

Sorry, I didn't get your point. How to use max() to switch between different text values in Column1?

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

e2liu77,

 

See code below.

IF (
    MAX ( table2[column1] ) =