Issue in creating relationship with date columns

[amansingh19]

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 !

[mussaenda]

Please elaborate the issue

[amansingh19]

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.

[BA_Pete]

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]

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