Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I Have this condition in Excel: =IF(Z6="NA",0,3), How do I Translate this to DAX Language?
Solved! Go to Solution.
Hi @ivansitoiv ,
For creating a column you could try:-
column = IF('table'[column_which_represent_z6]="NA",0,3)
and for measure it could be like this
Measure = IF(max('table'[column_which_represent_z6])="NA",0,3)
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @ivansitoiv ,
For creating a column you could try:-
column = IF('table'[column_which_represent_z6]="NA",0,3)
and for measure it could be like this
Measure = IF(max('table'[column_which_represent_z6])="NA",0,3)
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi,
I assume you want to create a calculated column.
Please check the below DAX formula whether it suits your requirement.
Excel CC =
IF ( 'table name'[Z6 column] = "NA", 0, 3 )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
The formula is to create a measure or calculated column? because im receiving this error: DAX comparison do not support comparing values of type integer with values of type text
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |