Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Variable in measure doesn't work properly

Hi, I would like to ask if somebody could help me with problem I have in on of my measures. I'm still learning how to use DAX properly. I want to calculate last year YTD data by period.  I don't ha...
  • johnt75's avatar
    johnt75
    3 years ago

    I think its likely that for the accounts which are returning blank you don't have data where the variable column is ACT but you do have data where the variable is BASE.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Oh yes! You are right. Thanks a lot. 

By the way, could you give me some advise how to change it so it could work for last year data? 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    You should be able to add an additional filter into the CALCULATE to work for whichever year you need, last year would be something like

    'Table'[Year] = YEAR(TODAY()) - 1