Forum Discussion
Calculated column filtered by two columns value
Hi, I have this calculated table, it has rows with values, colums with date of creation truncated to weeks and a check in value. I need another colum with the value of the last week (creation week ...
Try :
New Column = sumx(filter(Table,[Creation] = (earlier([creation]) - 7) && [Check in] = (earlier([check in]) - 365)),[room nights])
Did not get it completely
New column = [creation date]-7
The other I did not get
Hi
Thanks frist of all!
New Colum = sum(room nights) where Creation = creation - 7 and Check in = check in - 365
In SQL it´s easy 🙂
Cheers
Try :
New Column = sumx(filter(Table,[Creation] = (earlier([creation]) - 7) && [Check in] = (earlier([check in]) - 365)),[room nights])