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 one shows the same value.

 

thanks a lot.

Need Help

3 Replies

  • 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