Forum Discussion
Solved
Double Values
Hello I need help on a table. I would like to add a calculated column that gives me back a D or R value. R if the value is not double. D if the value is doubled Here are the columns id users...
Thx for you help, i just modified year +1 on year -1 for result D on first... in my case.. room student...
For understand, if i want compare two values, i must to create variable if i want filter?
Hi Yannick_M
you can try to create a new column with this:
Column =
VAR CurrentID = TableName[ID]
VAR CurrentRoom = TableName[Room]
VAR CurrentYear = TableName[Year]
VAR _count=
COUNTROWS(
FILTER(
TableName,
CurrentID = TableName[ID]
&&CurrentRoom = TableName[Room]
&&CurrentYear = TableName[Year]+1
)
)
RETURN IF(_count=1, "D","R")
i tried and it worked like this:
Thx for you help, i just modified year +1 on year -1 for result D on first... in my case.. room student...
For understand, if i want compare two values, i must to create variable if i want filter?