Forum Discussion
neees78
4 years agoHelper II
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
- 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
neees78
4 years agoHelper II
Jihwan_Kim it worked prefectly , Many thanks