Forum Discussion
Mapping Issue with Event Table and Calendar Table
Hello to all, In this case - Event table has the data where dates are not in a continous manner and Calendar table is the date range of Min/Max of Event_Date column. I'm unable to establish a wor...
Thanks menglaro78 for the reply.
From what I understand, for Time Intelligence to work date must be continous which is not the case in Events Table. Hence Solution A won't work.
I tried Solution B but it didn't work.
Mapping one-to-many is visible but when I select any month from Calendar Date in slicer, shows blank fields from Events Table.
Hi, is it possible to share your file?
This is not correct: Hence Solution A won't work..
In solution A , Power BI generate automatically generates a hidden calendar table with contiguous dates.
Marco
menglaro78, it is a client sensitive data. I'm not allowed to share it.
Anyways thanks for the help, I'll need to check some workaround for this.