Forum Discussion

amansingh19's avatar
amansingh19
New Member
2 years ago

Issue in creating relationship with date columns

I created date table using power query and made a relationship with existing data table for date field. But relationship isn't working.

 

I made the checks like "data type" , etc. but it is fine.

 

Please help how to deal with it !

 

Need Help

4 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

    Hi amansingh19 ,

     

    When you say the relationship isn't working, what do you mean by this?

    Are you getting errors? Are you not get expected result? What?

     

    Pete

    • amansingh19's avatar
      amansingh19
      New Member
      2 years ago

      Hi BA_Pete 

      I am not getting error but I am not getting any change in the numbers. It is showing the overall count by default irrespective of change in date.

      As I am using date column from "Date range" table and using "count of saleorderitemcode" as a visual & I made a relationship as mentioned above between Date range [Date] column and the data table "created" column.

      But, on using the  date range table I am not getting change in count of saleorderitemcode on changing the date range i.e. relationship for date isn't working properly.

      Hope, I made my point clear.

      Aman

  • amansingh19's avatar
    amansingh19
    New Member
    2 years ago

    Hi BA_Pete 

    I mean that on using "Date Table" as date field in visualization, the measures on the data field don't work or don't show change as it should show.