Forum Discussion
Mapping Issue with Event Table and Calendar Table
Hello aakif_aslam ,
you have two solutions.
SOLUTION A - WITHOUT TABLE DATE.
In Power BI, Option And Settings, in Current File|Data Load, setting ON option Time Intelligence.
In this case you can use SAMEPERIODLASTYEAR with Event Data.
SOLUTION B - WITH TABLE DATE.
Select Table Date and in Table Tools use option "Mark as Date Table".
To do this remeber this rules:
When you specify your own date table, Power BI Desktop performs the following validations of that column and its data, to ensure that the data:
- contains unique values
- contains no null values
- contains contiguous date values (from beginning to end)
In this case, use Date from Date Table in SAMEPERIODLASTYEAR .
Documentation here: Set and use date tables in Power BI Desktop - Power BI | Microsoft Learn
Marco
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.