Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
9 years ago
Solved

Difference between 2 columns in a Matrix Table - DAX Help ASAP

Hi all,   I have a problem that Vvelardeand Anonymous have been helping me with. They have done such a great job, however I have encountered an issue I need to fix it ASAP.   They have helped me ...
Need Help
Show and Tell
  • Boycie92's avatar
    Boycie92
    9 years ago

    Hi all,

     

    In case anyone has a similar issue. there is a pretty simple fix. Instead of Using Month.No I should have used [Date].[Date] in all of the formulas.

     

    I apologies for wasting all of your time on this.

     

    Thanks,

    Boycie92

Boycie92's avatar
Boycie92
Resolver I
9 years ago

Hi v-ljerr-msft

 

Thanks for looking into this for me.

 

I am a little bit confused. Do you know why this error was not showing when I used the Month instead of YearMonth?

 

Thanks again,

Boycie92

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Boycie92,

I am a little bit confused. Do you know why this error was not showing when I used the Month instead of YearMonth?

That's the part which confuse me most. Without changing the previous logic, just use YearMonth instead of Month shouldn't make such difference. Sorry, I am also lost on this issue.

 

Regards

  • Boycie92's avatar
    Boycie92
    Resolver I
    9 years ago

    Hi all,

     

    In case anyone has a similar issue. there is a pretty simple fix. Instead of Using Month.No I should have used [Date].[Date] in all of the formulas.

     

    I apologies for wasting all of your time on this.

     

    Thanks,

    Boycie92

  • Boycie92's avatar
    Boycie92
    Resolver I
    9 years ago

    Hi v-ljerr-msft

     

    I appreciate your help on this, i'm glad that i'm not the only one that's lost here!

     

    If anyone else in the community has any ideas I would love to hear them?

     

    Kind Regards,

    Boycie92