The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello all, iam new here and i need help please in some DAX tranlation in order to translate the below IF statement:
=IF(I735="Change",O735-N735,"00:00:00")
=IF(NOT(I735="Change"),O735-N735,"00:00:00")
Thans in advence
@loay_younis Below is how I read them.
=IF(I735="Change",O735-N735,"00:00:00")
If the row value in column I735 is "Change", then return O735 - N735 (I'm not sure how or if that will work), else return the text value of "00:00:00."
=IF(NOT(I735="Change"),O735-N735,"00:00:00")
If the row value in column I735 is not "Change", then do something with O735 - N735, else return the text value of "00:00:00."
User | Count |
---|---|
80 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
107 | |
99 | |
55 | |
49 | |
46 |