Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiple DAX VAR/RETURN IF

Hello All,   Coudl you please advise where can be a mistake if formula is the same but in 1st case it's working and shows different numbers for Year to Year and Month to Date numbers and the 2nd on...
Need Help
d_gosbell's avatar
d_gosbell
Super User
6 years ago
Anonymous wrote:

Hello All,

 

Coudl you please advise where can be a mistake if formula is the same but in 1st case it's working and shows different numbers for Year to Year and Month to Date numbers and the 2nd one shows the same value.

 

That would imply that there is maybe something wrong with the relationship between the 0_Calendar and BC_AC_Eur tables. Either the filtering is in the wrong direction or the relationship is missing altogether. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    No, we've checked everything what u mentioned and it's ok

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      hi Anonymous 

      If so, it should be that 'BC_AC_Eur'[BC_AC] is a datetime column and is not only 12:00:00, so although you have create the relationship between it with calendar table, by they couldn't have the corresponding value.

      If not your case, please share your sample pbix file for us have a test.

       

      Regards,

      Lin