Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help with DAX

Hello, Hope you all are doing great.   I am stuck in one conditional DAX formula  I have one table in which I have 5 Columns trdr1, trdr2, week, trdr1 prft and trdr2 prft.   Now I want to calcul...
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

not sure if i got you correctly but you could try using if or switch 

Condition = 
SWITCH(
     TRUE(),
     AND('table'[trdr1] = 51 , 'table'[week] = 1) , sum('table'[trdr1]),
     AND('table'[trdr2] = 51 , 'table'[week] = 2) , sum('table'[trdr2]),
     AND('table'[trdr1] = 51 , AND('table'[week] = 1, table'[trdr2] = 51)) , sum('table'[trdr1]),