Forum Discussion

Marke525's avatar
Marke525
Frequent Visitor
6 years ago
Solved

Create Measures tutorial not working

I am trying to follow the tutorial and have come across this problem:  In the tutorial a matrix table is created like this:   It is revenue over month and year.  When I create the table and a...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Thanks for providing the pbix file.  The issue is that the Date column in your date table only has the month and day (no year).  If you make the relationship to the Date2 column instead, and make sure both the Date2 in the Date table and Date column in your Sales table both have data type Date, your visual will work correctly.  One of those two columns was text format, so needed to be changed.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

Thanks for providing the pbix file.  The issue is that the Date column in your date table only has the month and day (no year).  If you make the relationship to the Date2 column instead, and make sure both the Date2 in the Date table and Date column in your Sales table both have data type Date, your visual will work correctly.  One of those two columns was text format, so needed to be changed.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Marke525's avatar
Marke525
Frequent Visitor
6 years ago

That was perfect, well explained advice.  Thank you for your help, I really appreciate it.