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

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

That looks like a bad join between Sales and Dates.  Can you share your .pbix file?  Upload it to OneDrive or DropBox and share the link here.