Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ehsanulhoque
New Member

Master Calendar

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?

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

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
Super User
Super User

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 ::

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors