Forum Discussion
kasiaw29
Resolver II
Resolver IIDate Dimension not working properly
Hi community,
I have a simple date dimension table, build it as a new table + some columns for the usual day, month, week no, etc.
Date Dimension = CALENDAR(DATE(2016,1,1),DATE(2099,12,31))
I also have a facts table, in this example called Payment Milestones with 1-many relationship:
Payments milestones can have few payments occurring on the same date, so naturally I wanted to see how many and which ones fall on what day, but this does not seem to work when put on a simple bar chart:
Anyone any ideas?
Nevermind. The issue was sorted in power query...trying to match date and time to date.
1 Reply
- kasiaw29
Nevermind. The issue was sorted in power query...trying to match date and time to date.