Forum Discussion
Anmolgan
Post Prodigy
Post ProdigyHow to combine two DAX functions into one?
I have two dax functions that looks like this below:
Measure4 = CALCULATE(sum(f_Kronos[Minutes]) - "60", FILTER(f_Kronos, f_Kronos[Subtraction Column]= "Subtract 60"))
Measure 3 = CALCULATE(sum(f_Kronos[Minutes]) - "30", FILTER(f_Kronos, f_Kronos[Subtraction Column]= "Subtract 30"))
I want to combine them into single formula so that I can get the above two working as per single column in the table, is that possible?
8 Replies
- edhans
Community Champion
Combine them how? Either/Or would be OR() or ||, And would be AND() or &&, or you could evalueate with an IF() statment to return one or the other.
If you want to add them, just put a + between them.Otherwise, please explain your desired output.
AnmolganBelow is the file where am trying to do this, check page 2 and measure 3 and measure 4
