Forum Discussion
Need help adding a calendar table to my data model
Community ChampionHello Anonymous,
can you please refer to this article and tell me if it works for you , or do you need a specific kind od calendar table ?
https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query
you have the M query code and the DAX query code,
I have already created the calendar table. The issue i am running into is being able to connect it to the 3 tables that i am using for the 3 measures that make up the Employee Productivity %
- Daniel29195
mmm ok sorry,
i checked the image just now,
your model is somehow complex
there is a lot of many to many with bidirectional filters which i assume is the reaon you cant connect the calendar table to all other tables.
i think you can create inactive relationship between the calendar and the 2 other tables .
and in the dax measure,
whenver you need to use that relationship,
write :
calculate ( aggregation , userelationship ( id 1 , id2 )
)
https://learn.microsoft.com/en-us/dax/userelationship-function-dax
https://dax.guide/userelationship/or you can ignore creating inactive relationships and just propagate the filters using treatas function in DAX .
https://learn.microsoft.com/en-us/dax/treatas-function
https://dax.guide/treatas/
hope this helps .best regards