Forum Discussion

RenateBK's avatar
RenateBK
Icon for Helper II rankHelper II
11 months ago
Solved

Date dimension to a table with multiple date columns calculations - ensuring it's correct set up

Hello,    I am in need of a confirmation that I have set up the relationships and connections correct for my report. I am connected to a datalake for my first time so I am in slightly unknown water...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    11 months ago

    Hi RenateBK 
    If numbers are still not matching then you can try below approach

    • create a table visual
    • drag drop datekey columns from dim date and fact table
    • add your measure 
    • check if the datekeys are matching or are there any blanks
    • if there are no blanks and keys are matching try checking the numbers for a year,qtr,month

    Let me know if it helps.

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
11 months ago

Hi RenateBK 
If numbers are still not matching then you can try below approach

  • create a table visual
  • drag drop datekey columns from dim date and fact table
  • add your measure 
  • check if the datekeys are matching or are there any blanks
  • if there are no blanks and keys are matching try checking the numbers for a year,qtr,month

Let me know if it helps.

RenateBK's avatar
RenateBK
Icon for Helper II rankHelper II
11 months ago

Hello Praful, 

 

Thank you so much for the advice, I have gone through it and double checked it all and it should be good now 🙂

 

Best regards, 

Renate