Forum Discussion

jiangxm80's avatar
jiangxm80
Helper I
3 years ago
Solved

Add one more columns

I would like to add one more columns, which would be equal to the RV line of each set of records.   Column1   Column2    Column3 A                RV              100 A                AB          ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Column4 CC =
MAXX (
    FILTER (
        Data,
        Data[Column1] = EARLIER ( Data[Column1] )
            && Data[Column2] = "RV"
    ),
    Data[Column3]
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Column4 CC =
MAXX (
    FILTER (
        Data,
        Data[Column1] = EARLIER ( Data[Column1] )
            && Data[Column2] = "RV"
    ),
    Data[Column3]
)

 

jiangxm80's avatar
jiangxm80
Helper I
3 years ago

Thanks a lot!