Forum Discussion

neees78's avatar
neees78
Helper II
4 years ago
Solved

Calculated Column using other columns

Hi All, 

 

Using the following sample table - is it possible to have calucated column - showing tomorrow's Value 

using user name & date as filter ? 

 

 

Thanks 

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Tomorrow value CC =
VAR currentdate = Data[Date]
VAR currentuser = Data[User]
VAR result =
    CALCULATETABLE (
        VALUES ( Data[Value] ),
        FILTER (
            ALL ( Data ),
            Data[Date] = currentdate + 1
                && Data[User] = currentuser
        )
    )
RETURN
    result

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Tomorrow value CC =
VAR currentdate = Data[Date]
VAR currentuser = Data[User]
VAR result =
    CALCULATETABLE (
        VALUES ( Data[Value] ),
        FILTER (
            ALL ( Data ),
            Data[Date] = currentdate + 1
                && Data[User] = currentuser
        )
    )
RETURN
    result