Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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 | Room | Year | Column measured |
| id111 | 1 | 2010 | |
| id333 | 1 | 2010 | |
| id1111 | 1 | 2011 | D |
| id333 | 2 | 2011 | R |
i know the algorithm, but i dont scrive this in dax
i must to look if my room users is same than one year ago, if yes the result will be D or not then result is R
i think to use parallellperiod or sameperiodlast year, but i'm blocked on filter to use that
Sorry for my english
i hope someone will can to help me
Regards
Solved! Go to Solution.