Date table with duplciate values for each calendar type

[Hikmer]

I am working with a pre-existing DIM CALENDAR that has duplicate values for dates (Calendar, Fiscal and Merch).  How can I best deal with this in a Tabular model where the Date field needs to be unique for date table calculations?  I'm starting by making a calculated table that is filtered by calendar type but now I realize this will not work effectively for measures that require a calculation for all calendar types.   

[Greg_Deckler]

Is this import or live? If import, just bring the table in and remove duplicates in Power Query.

[Hikmer]

Live connection to a Tabular Model, this is more a DAX question than PowerBI.   Also, the complexity of having duplicate values in the date table would still apply to an imported model.   I want to keep the duplicates and filter on the calendar type.

[v-ljerr-msft]

Hi @Hikmer,

Live connection to a Tabular Model, this is more a DAX question than PowerBI.   Also, the complexity of having duplicate values in the date table would still apply to an imported model.   I want to keep the duplicates and filter on the calendar type.

---

Could you post your table structures with some sample data and your expected result, so that we can better assist on this issue? 

Regards

[Hikmer · Accepted solution]

I was able to get some feedback on a DAX forum as the solution was to add columns with the Fiscal and Merch groupings instead of having these in separate rows.  There may be a way to get this to work but the level of effort and complexity isn't worth it at this moment.