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

      • 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