Zendesk Data Model

Hi Anonymous ,

Connecting a date table properly in Power BI can be a bit tricky, especially when dealing with data from external sources like ZenDesk. Here are some steps you might find helpful:

Ensure the Date Field is Correct: Make sure the date field in your date table is of the correct data type (i.e., Date or Date/Time) and contains unique and continuous dates.

Create Relationships: In the Power BI data model, create a relationship between the date field in your date table and the corresponding date field in your ZenDesk tables. Make sure the relationship is active and of the correct type (usually one-to-many from the date table to the ZenDesk table).

Mark as Date Table: In Power BI Desktop, mark your date table as a date table. This tells Power BI to use this table for time intelligence calculations.

Use USERELATIONSHIP Function: If there are multiple relationships between tables, you might need to use the USERELATIONSHIP function in your DAX calculations to specify which relationship to use.

Check for Blanks or Errors: Make sure there are no blank or error values in your date fields that might be causing issues with the relationship or calculations.

Best Regards