Forum Discussion
How to Fix the relationship with my date table?
I figured it out!
the date field includes time information (e.g., a timestamp), Power BI might treat each unique timestamp as a separate day.
So I created a new date column
Invoice Date =DATE(YEAR('OVH Sales'[INVOICE DATE]), MONTH([INVOICE DATE]), DAY([INVOICE DATE]))
Then changed the relationship to this new date and now it works.
Super UserHi Anonymous ,
You refer that you have a relationship one to many from the invoice date to the calendar date if the relationship is exactly has you describe then you have the relationship in the incorrect direction you must have the one side of the relationship on the Calendar table and the many side on the invoice table.
If you have that relationship then you don't need to use the invoice date on your visual but if you want you can.
hi, yes I have the one side on my calendar side but still not working properly. This is what happens when I remove the Invoice Date. it only show two dates and its weird.
- MFelix
Hi Anonymous ,
Sorry for the question but are you columns properly formatted? Are they both has dates on the semantic model?
Hi,
yes, they are both dates. It wont let me summarize the invoice date though?
When I do a date hierarchy is shows properly:
But when I change it to date, it shows by line level enough though the relationship is correct?