How to get a visual coming from two different tables with different date tables each?

[afaro]

I have a table TA with calendar date table as CA which has a monthly granularity. 

I have a table TB with calendar date table as CB which has a daily granularity. 

I want to show a visual showing measures from TA and TB with a quarter-year on the x axis. 

Using CB for TA is most likely not an option for me as those tables were imported from another semantic model.

How can I do this?  

[Anonymous]

Thanks for the reply from @rajendraongole1 , please allow me to provide another insight:
Hi,@afaro 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.Next create relationships between tables:

3.Then the date with a hierarchical structure with a month is used as the content of the visual object:

4.Here are the Settings for other visual objects:

5.The following is the relevant documentation, hope to help you:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

6.Here's my final result, which I hope meets your requirements.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[afaro]

Sample data would be something like this: 

Table A 

CA Date	Value
1 Jan 2022	1000
1 Feb 2022	2000
1 March 2022	3000

Table B 

CB	Value
1 Jan 2022	10
2 Jan 2022	20
....... All the dates in between daily	6000
31 March 2022	10

Now, the date table CA definition only has one date per month so it has monthly granularity while CB has every single date of the year(s). 

I want to see a visual where 

I see total value on y axis as 6040 for TB and 6000 for TA for Quarter 1.  

@rajendraongole1 @Anonymous 

[Anonymous · Accepted solution]

Hi,@afaro 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.Next create relationships between tables:

3.Visual object parameters are set as follows:

4.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

[rajendraongole1]

Hi @afaro - Question is not clear, can you please help to share some sample data or example? are you looking for common quarter-year x-axis, effectively combining data from tables with different date tables?

Re: How to Get Your Question Answered Quickly - Page 7 - Microsoft Fabric Community

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!