Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX Issue.

Hi  Experts,   When I'm trying to create a measure I stuck up with below issue. Basicaly here I'm trying to display previous year values. I can use datediff but my column RPT Year is in Whole numb...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

maybe you can try this

Test = CALCULATE(SUM(Query[Jan]),Query2[RPTyear]=SLECTEDVALUE(Query2[RPTyear])-1))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    When I'm using selectedvalue function getting below error

    Error:

    A function 'SELECTEDVALUE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.