Forum Discussion

timazarj's avatar
timazarj
Helper II
5 years ago
Solved

Table relationships

Hi,   in my model I have a Date table, using it a slicer, Employee table, using it for usercode. there are 2 different tables for Sales and Returns. I created the relationship between the Date to S...
Need Help
  • SivaMani's avatar
    SivaMani
    5 years ago

    timazarj,

    Date(Date and Sales Table) is the culprit. Make sure that you have matching records for Date.

SivaMani's avatar
SivaMani
Resident Rockstar
5 years ago

timazarj,

X-DAT and Upsells are calculated measures?

timazarj's avatar
timazarj
Helper II
5 years ago

yes they are.

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    5 years ago

    timazarj,

    Date(Date and Sales Table) is the culprit. Make sure that you have matching records for Date.

    • timazarj's avatar
      timazarj
      Helper II
      5 years ago

      I ensured that the Date column, EffectiveDate, and EnteredDateTime in the three tables have the same data type and format, and there are matching records for Date. Still no result.

    • timazarj's avatar
      timazarj
      Helper II
      5 years ago

      I changed the data type of the Return table in Power Query and it worked.