Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hello , please i need some help here what i have
if ( ca = 0 ) in date1 and ca <>0 in date2 then 'new'
else if ( ca in date1 < ca in date2 ) then 'up')
else if (ca in date 1 > ca in date then 'down')
else if ca <> 0 in date1 and ca = 0 in date 2 then 'unkhnown')
so i try to write it with dax like this
if ( (ca=0 , date1 ), 'nouveaux' , if(ca <>0 , date2), 'nouveaux', if ((ca , date1 )<(ca , date2), 'croissance', if ((ca , date1 )>(ca , date2), 'perte',if((ca<>0 , date1 ), (ca =0 , date2),'null')))))
or
if ( (ca=0 , date1 ) && (ca <>0 , date2); 'nouveaux'; if ((ca , date1 )<(ca , date2); 'croissance'; if ((ca , date1 )>(ca , date2) ; 'perte' ; if((ca<>0 , date1 )&&(ca =0 , date2);'null')))))
I have a problem to acces to power BI so until i found a solution i want to be sure that my dax querry is right .
Any suggestion please
thank you
Solved! Go to Solution.
Hello, Switch should be perfect.
I assume two measures,
CA1 for ca in date1 and CA2 for ca in date2.
Switch(
TRUE(),
[CA1]=0 && [CA2]<>0, 'new', --condition 1
[CA1]>[CA2], 'up', --condition 2
[CA1]<[CA2], 'down' --condition 3
[CA1]<>0 && [CA2]=0, 'unknown' --condition 4
BLANK()) --else
For further information check this article.
I hope this helps. I want miss the SWITCH function anymore.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |