Create a additional Calendar table in addition to the existing one

[sivarajan21]

Hi

I have below model setup in the power bi report:

We have a calendar table to filter the 'cumulus_licensee estatemanagement_dataelectricity' table.

We have a requirement to filter the 'cumulus_licensee estatemanagement_contacts' table as well using the Calendar table. 

Is it possible to create a simple calendar table to filter the 'cumulus_licensee estatemanagement_contacts' table  without disturbing the existing Calendar Table?

Please help me resolve this!

PFA file in Timetravel (1).pbix

Thanks in advance!

@Ahmedx @Greg_Deckler @amitchandak @marcorusso 

[ChielFaber]

Don't have the complete answer cause you need some advanced dax. If you need another date table you can just add a new one though PowerQuery: https://gorilla.bi/power-query/date-table/  or DAX https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/ 

But the important step comes after the creation of the date table. If you simply connect the new date table to the cumulis_licensee_estatme any filtering based on the new calendar table will trickle down the other tables. To prevent this you should make the relationship inactive. You can then create a dax code with the calculations you need to use the userelationship function and crossfilter to deactivate the other relation with crossfilter.

You could look into crossfilter for example in this post: https://community.fabric.microsoft.com/t5/Desktop/Inactivate-relationship-dax/m-p/878742 

[ChielFaber]

Don't know al the filter requirements but if it's possible the easiest solution would be to change this connection into a one-way connection from Contract to cumulis_licensee_estatme instead of both ways. If it's possible to change this you can then just connect the calendar to the  cumulis_licensee_estatme table

[sivarajan21]

Hi @ChielFaber ,

The requirement is to see the trend of number of sites(count of dbname-contact_id) over time instead of having to select a date from slicer.

for example in below screenshot:

We have a table that is filtered by contacts date slicer and card showing count of DBName-contact_id.

We have a requirement to create a trend of counts over calendar time in a bar chart or any suitable trends visual. 

For that we need a separate calendar table that is connected to 'cumulus_licensee estatemanagement_contacts' table to filter it.

please let me know if you need further info!

Please hel me to resolve this issue!

Thanks in advance!

@amitchandak @v-tangjie-msft @Greg_Deckler @Ahmedx @ChielFaber @jdbuchanan71