Forum Discussion
IF statement and for each
Hello, i am new using DAX, I am using a IF statement in a custom column to add some fixed values in my costs table, i am just adding the fixed values for some specific cases where i have other co...
Hello Anonymous
could you batter exemplify what you would like to do?
Hi, Gabriel, sure.
My current IF formula is adding a fixed price for lines where I have specific values for MeterCategory, MeterRegion and MeterName and it is working fine. now I need to apply the same logic, only when the Month values is equal or before November 2020. My target is to add another custom column where I will do another IF formula to add other fixed prices for lines after November 2020, so December onwards, so I need have it in order to show some fixed values according my IF formulas, before November and another after december.
I would like to do it, using the same custom column code i posted in my first post, but adding the Month condition.