Forum Discussion
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. ...
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
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