Multiple DAX VAR/RETURN IF

[Anonymous]

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.

[d_gosbell]

---

@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]

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

[v-lili6-msft]

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