Master Calendar

[ehsanulhoque]

I have 2 tables. 1 contains monthly values and 2nd one contains quartly values. Month wise values can't be added to get the quarterly values. But I want to use single calendar to get the both values. Suppose when I am selecting monthly values, it will show data from 1st table and when I'm selecting data for a quarter it will show data from 2nd table which contains quarterly values. How can I do that?

[v-stephen-msft]

Hi @ehsanulhoque ,

Can you tell me the format of the month in the first table and the quarter in the second table? Whether the data of these two tables can be related through a calendar table.
If you want to understand the dynamic x-axis, you can refer to:

Dynamic change in X Axis

Best Regards,

Stephen Tao

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

[collinq]

HI @ehsanulhoque ,

This is simple to do if you use a DateTable and combine use that to put the two tables together.  You would hook the "datefield" from each table to the DateTable and then you can mix and match to your heart's content.  There are plenty of Date Tables if you search for them but here is one that you can copy from:  Why Create a Date Table in Power BI? : :: Welcome To EPM Strategy ::