cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ogruss Frequent Visitor
Frequent Visitor

Daily calender vs Monthly Data

Hello Community,

 

i got a little understanding issue with PowerBi Daily Calenders, monthly calenders and the underlying data.

 

1) I have made a daily Calender with the following for this post releveant columns:

  • Daily Date
  • Month Date (e.g. 01.03.2018, for all dates in March ("02.03.2018";"03.03.03.2018 etc...)

2)  I have monthly data for sales

  • 100k - 01.03.2018

Due to the requirements of PowerBI i can not link the Calender table to the Sales table (n:n relationship)

 

3) I therefore created a monthly date table only consisting of monthly dates.

 

--> Can be connected to the Sales table (1:n relationship)

 

Question:

Is there a possibility to link monthly data to a daily calender ???

If so i could load in daily sales data as well and combine reportings.

 

 

Thank you very much in advance

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Daily calender vs Monthly Data

You should be able to connnect your table with unique values to both tables. As long as your cross-filtering directions are set correctly in your relationships then the two tables are connected and you effectively have a many-to-many relationship.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: Daily calender vs Monthly Data

You should be able to connnect your table with unique values to both tables. As long as your cross-filtering directions are set correctly in your relationships then the two tables are connected and you effectively have a many-to-many relationship.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!