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 

 

Try DISTINCTCOUNT or DISTINCTCOUNTNOBLANK on Case ID column instead of COUNTROWS.

 

Let me know if it works.

Please Give a Kudos or mark it as resolved if it helps.

Thanks and Regards,

Praful

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

    Hello, 

     

    Thank you for your feedback, I've adjusted the measurement so it includes DISTINCTCOUNTNOBLANK now which is a nice fail safe to include in case some blank Case ID's end up in the data set. 

     

    The numbers stay the same so it doesn't seem to be anything there, it could be that the previous reporting had some lag due to it being manually exported through a UI, if there's nothing else wrong about the set up (that I described in the first post)