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 September 15. Request your voucher.
Creating a new Column or Change original - I am trying to Divide a Value in a Column based on the Value's Name. I have multiple NAMEs and VALUEs to change. I am unable to add multiple IF statements. Also if the NAME is not defined how do I pass the original Value to the new column?
Solved! Go to Solution.
You could specify another IF() function in the ResultFalse (aka else) parameter. The last IF() would return the original value. See: IF – DAX Guide For example
Column = IF('DSR'[Name]="CureTimeValue",[VALUE]/10,
IF('DSR'[Name]="SomethingelseValue",[VALUE]/15,
[Value]
)
)
Another, maybe better option is Switch() SWITCH – DAX Guide. Example:
Column = SWITCH('DSR'[Name],
"CureTimeValue",[VALUE]/10,
"SomethingelseValue",[Value]/15,
[Value]
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Hi @JacksonMaui
best is to have all names vs the related value in a lookup (dimension) table. The easiest and most efficient way to proceed after that is to create a one to many relationship. The rest wiuld be a piece of cake.
You could specify another IF() function in the ResultFalse (aka else) parameter. The last IF() would return the original value. See: IF – DAX Guide For example
Column = IF('DSR'[Name]="CureTimeValue",[VALUE]/10,
IF('DSR'[Name]="SomethingelseValue",[VALUE]/15,
[Value]
)
)
Another, maybe better option is Switch() SWITCH – DAX Guide. Example:
Column = SWITCH('DSR'[Name],
"CureTimeValue",[VALUE]/10,
"SomethingelseValue",[Value]/15,
[Value]
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
20 | |
12 | |
10 | |
7 |