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
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