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

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

Hi Boycie92,

 

Could you share a sample pbix file which can reproduce the issue in this case? So that we can help to investigate this issue. You can upload it to OneDrive or Dropbox and post the link here or just send me the link in private message. Do mask sensitive data before uploading.:smileyhappy:

 

Regards

  • 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