Calculated Column using other columns

[neees78]

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 

[neees78]

@Jihwan_Kim  it worked prefectly , Many thanks 

[Jihwan_Kim · Accepted solution]

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