Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 advise me how to create this connectionn?
Solved! Go to Solution.
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.
Hi,
Though it may not matter, please change the Cardinality and Cross filter direction to Many to One and Single.
Hi,
You should create a Calendar Table first. Using the LOOKUPVALUE() function, bring over the Holidays from the PHolidays table to the Calendar Table. The Calendar Table should have a relationship with the other tables.
I created relationships to my tables. It does not display when a try and create a visualisation with different measures in powerbi? see: https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing and https://drive.google.com/file/d/1n6oJToedcG0lfh06Xq2RO5j1l-3pUYeR/view?usp=sharing
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.
Thanks, can you send me the pbix?
I have not kept the PBI file. Just write the calculated column formula as mentioned in my previous message.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |