Forum Discussion

AndradeRobson's avatar
AndradeRobson
Helper II
3 years ago
Solved

Calculate formula by term

Dear, good afternoon!   I need some help with the DAX formula.   I have a formula that already calculates correctly every month, but I need this formula to be divided in two ways, being:   The ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi AndradeRobson ,

     

    Use selectedvalue() to wrap the date column.

    Measure C = IF(selectedvalue(calendar[date])<=date(2022,9,30),[Measure A],[Measure B])