Forum Discussion
Helper ICalendar since September Update
Hi Terry,
The cause is the dates in [fact***entry] are datetime rather than date. I added a new column and changed the relationship. It returns normal now.
New key Date.Datetime = [Key Date.DateTime].[date]
Best Regards!
Dale
Helper IThanks for the reply Dale,
Not sure, exmaple is below.
Key Date.DateTime is below, the dataset has been set to date, I have duplicated the column and transformed to year format, shown below as Key Date Year.
When I drag the two next to each other into a matrix I get the following results, really weird.
Some years show corrrectly and some are completely wrong.
Microsoft EmployeeHi CMAC_Terry,
Could you please share your PBIX file? The picture doesn't show your issue of your first post.
Best Regards!
Dale
- CMAC_Terry
Is there a way to attach a file, if not I can share the link through one drive to your email address.
- v-jiascu-msft
Sharing the link of OneDrive is OK. If you can't post it here, you can send me private message.
Best Regards!
Dale
- CMAC_Terry
I'm trying to create a calendar that links the two datasets so I can cut the Bill Net from both sets by year, month, date etc.
Let me know if the link doesn't work. Thanks for all your help.
Regards,
Terry