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