Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Helper V
5 years ago
Solved

Data Modeling - Date Table

I have this data: https://drive.google.com/file/d/1aHULztI9Q0Ho7ffoRcBceAiElOTIZVji/view?usp=sharing I need to create a connection between the Pholidays table and the rest of the tables. Please advi...
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Write this calculated column formula in the Date Table

    Column = LOOKUPVALUE('PHolidays (2)'[Public Holiday],'PHolidays (2)'[Date],'Date'[Date])

    Now ensure that all your tables are connected only to the Date Table.  Whenever you want to view any information by Public Holidays, drag that column from the Date Table (not from the PHolidays table).

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Write this calculated column formula in the Date Table

Column = LOOKUPVALUE('PHolidays (2)'[Public Holiday],'PHolidays (2)'[Date],'Date'[Date])

Now ensure that all your tables are connected only to the Date Table.  Whenever you want to view any information by Public Holidays, drag that column from the Date Table (not from the PHolidays table).

Hope this helps.

 

  • Yrstruly2021's avatar
    Yrstruly2021
    Helper V
    5 years ago

    Thanks, can you send me the pbix?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      I have not kept the PBI file.  Just write the calculated column formula as mentioned in my previous message.