Forum Discussion

IffyN's avatar
IffyN
Regular Visitor
8 months ago
Solved

Dimdate table isn't working

I am new to using Power BI. I'm trying to create a PBI report from a semantic model I created on Fabric, but I get this error. Because my model didn't have a date table, I created one on Fabric using...
Need Help
  • syahmisi98's avatar
    syahmisi98
    8 months ago

    You have a few options to fix it:

    1. Use a truly unique key for the relationship

    Instead of MonthNumber, use a column like:

    • FullDate (YYYY-MM-DD)
    • DateKey (e.g., 20250101)
    • YearMonth (e.g., 202501)

    These are unique at the date or month level and are suitable for the one-side of a relationship.

    2. Create a unique Year-Month key

    If your fact table is at a monthly granularity, create a new column in DimDate:

    YearMonth = dimdate[Year] * 100 + dimdate[MonthNumber]


    This will ensure values like 202501, 202502, etc., which are unique.

syahmisi98's avatar
syahmisi98
Advocate I
8 months ago

You have a few options to fix it:

1. Use a truly unique key for the relationship

Instead of MonthNumber, use a column like:

  • FullDate (YYYY-MM-DD)
  • DateKey (e.g., 20250101)
  • YearMonth (e.g., 202501)

These are unique at the date or month level and are suitable for the one-side of a relationship.

2. Create a unique Year-Month key

If your fact table is at a monthly granularity, create a new column in DimDate:

YearMonth = dimdate[Year] * 100 + dimdate[MonthNumber]


This will ensure values like 202501, 202502, etc., which are unique.