Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
can you please help on this error.
when i create a custon column with sum(if [column] ="" then "" else "")
i am getting the error.
Thanks,
Kishore
Solved! Go to Solution.
Hi @kishoresakamuri,
If you create a calculated column use DAX, you can't write a expression in SUM( ) function. You can use the SUMX( ) function like below:
Column = SUMX('Table1',IF('Table1'[ID]="a",0,'Table1'[Amount]))
Column 2 = SUMX(FILTER('Table1','Table1'[ID]<>"a"),'Table1'[Amount])
Best Regards,
Qiuyun Yu
use the below code it will help .
column = if( column=" A ", " B " , " C " )
if not let me know i will help u
Hi @kishoresakamuri,
If you create a calculated column use DAX, you can't write a expression in SUM( ) function. You can use the SUMX( ) function like below:
Column = SUMX('Table1',IF('Table1'[ID]="a",0,'Table1'[Amount]))
Column 2 = SUMX(FILTER('Table1','Table1'[ID]<>"a"),'Table1'[Amount])
Best Regards,
Qiuyun Yu
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |