Create Calculated Column based on the result of a measure
Hello! I need to create a calculated column that places a text depending on whether the condition of a measure is met
This is my table where I must create the Calculated Column:
I require that if the Field [MesSK] is equal to the value of the measure [Mes0] I put "Current Month" if the value of the field [MesSK] is equal to the value of the measure [Mes1] I put "Previous Month", if the [MonthSK] field is equal to the value of the measure [Mes2] I put "Same month of the previous year", if the condition is not met I put "Not Applicable"