Forum Discussion
Anonymous
5 years agoNot applicable
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...
amitchandak
Super User
5 years agoAnonymous , No very Clear. You can use Date.ToText to get year month and then use that in your formula
Anonymous
5 years agoNot applicable
Hello, thanks for you answer.
Could you help me with more details,
your suggestion is to transform my date column into two new columns with the Month and Year information, (text), I could add this column as a condition to my previous formula?
There is a way to do it in a single line, instead of add the Month and Year condition for all lines in my previous formula?
l