Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Measure in Calculated Column

Hi everyone, I', having a DAX problem. I've tried to solve it but to no avail. I'm trying to create a calculated column to flag if a record should show as this year.   I have a planning table: Fis...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello you could dim your measure inside your formula:

     

    VAR CurrentYear=...Concatenate...
    RETURN
    IF( CALCULATE(VALUES(Dates[FiscalYearSlash]),
                        FILTER(Dates,
                        Dates[FiscalYear]=Planning[FiscalYear]))
= CurrentYear,"yes","no")
Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello you could dim your measure inside your formula:

 

VAR CurrentYear=...Concatenate...
RETURN
IF( CALCULATE(VALUES(Dates[FiscalYearSlash]),
                        FILTER(Dates,
                        Dates[FiscalYear]=Planning[FiscalYear]))
= CurrentYear,"yes","no")
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks. Funnily enough it occurred to me to try this after posting. I'll have a go now and mark as accepted if it works.

 

General question on the same topic: are measures allowed in calculcated columns?

  • Floriankx's avatar
    Floriankx
    Solution Sage
    8 years ago

    Hello,

     

    generally they are, but calculated columns are row based and measure column based so I try to avoid it if possible.