Connecting Week on Week Data to Calendar fact Table

[jhauw74]

Hi Experts,

I have an issue where I have two tables:
1. is week on week total

2. calendar fact tabe

How can I join the two so that I can make visuals that based on Calendar?
The calendar table does have a column that has the same format as the #1 table & when I join the two the relationships is become * to 1 

TIA for assistance as always 🙂

[Ashish_Mathur]

Hi,

Remove the WE from the column of both tables.  Now create a Many to One relationship.

[Ritaf1983]

Hi @jhauw74 

You can add a column with an extracted date and relate the table to the calendar table by this new column.

To get an extracted date easily  you can use an option "column from example" "

Pbix is attached you can follow my steps

More information about the column from  example here:

https://www.youtube.com/watch?v=UG26NKSNqoc

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[amitchandak · Accepted solution]

@jhauw74 , Assume you do not have data at date level
You can create date based on date part you have in the date

Date = datevalue(right([Week COlumn],10))

Then you can join if with calendar table having week and create WOW measures

Calendar
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...
https://medium.com/chandakamit/cheat-sheet-any-weekdays-week-start-date-just-one-variable-apart-6b2e...

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510