Forum Discussion
Combine 4 Measures into One Column
Hi,
I have the following logic which essentially combines 2 measure into the one column. However, I have added in 2 extra measure that also need to be added into the logic below, any idea how I would do this please?
2 Replies
You are not clear what are conditions for other measures, but Take a look at these:
https://community.powerbi.com/t5/Desktop/DAX-Measure-with-Nested-IF-Statements/m-p/113358
https://blog.enterprisedna.co/using-advanced-dax-for-multiple-if-statement-in-power-bi/
https://stackoverflow.com/questions/40254578/multiple-if-statements-in-dax
you basically can use nested IF statement.
Hi Anonymous ,
Maybe you can try CONCATENATE(<text1>, <text2>) or & to combine them. For example:
offset = IF(app_spend[app_bal]<>BLANK(),
CONCATENATE(app_spend[app_bal], app_spend[app_in]) ,
app_spend[new_bal] &" "& app_spend[app_out] )
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
