Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Yannick_M
New Member

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 usersRoomYearColumn measured
id11112010 
id33312010 
id111112011D
id33322011R

 

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