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

 

I was wondering if you have had the time to look at the issues I am having?

 

Thanks,

Boycie92

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

    Hi Boycie92,

     

    I am the one to apologise. Sorry for the delay response.

     

    I did spend a lot time looking into your shared pbix file. Then I found the issue may relate to the previous logic of your measures which are a little complex for me to understand. After a few try, I was still not able to fix your issue. :smileymad:

     

    Regards

    • 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