Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date relationships between four separate tables

I have five separate tables each with a column 'Created' This column tells us when each row was created in <dd/mm/yy> format.   I want to create a bar graph that tells us how many rows were create...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Create a Date table with date key and 

You can create a new column for date key in all five tables and link that to Date table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous  I'm unfamiliar with date keys & how to produce them. Could you provide an example if possible?

     

    Cheers

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Cameron,

       

      Date key for today 14th August 2019 is 20190814  this will be available in all the Date dimension table that you download from internet.

       

      So you can create a column in all your tables for date key and map it with the date table

    • RobbeVL's avatar
      RobbeVL
      Icon for Impactful Individual rankImpactful Individual
      7 years ago

      Could you provide a sample of your dataset?
      I will see if I can create a DateDimension for you with the correct structure.

       

      Your DateKey is depending on how your data is structured and formatted.
      If you share a few rows of your data, I'll prepare a Pbix samle for you.

       

      robbe

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        By all means that would be excellent. 

        How do I attach a sample?

         

        I've attached a photo below how far I've gotten.