Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

Case 001 How to add master calendar to my sales table ?

Hi All


I just manage import a sales table to PBI.


Customer/VendorCustomer NameAR Invoice NumberAR Invoice DateMonthRow Total (SGD)Row Total w/ VAT
CIT00023-EURSU ZHOU SERVO DYNAMICS CO., LTD300002033/7/2003Mar2,036.962,036.96
CIT00023-USDSU ZHOU SERVO DYNAMICS CO., LTD300002043/10/2003Mar347.4347.4
CIT00023-USDSU ZHOU SERVO DYNAMICS CO., LTD300000052/3/2010Feb369.81369.81
CET00050DPL TECHNOLOGIES & SERVICES PTE LTD300000076/8/2011Jun600600
CIT00023-USDSU ZHOU SERVO DYNAMICS CO., LTD3000000401/15/2010Jan623.55623.55

Can some one advise me how to add master claendar m so that i can get Qtr , YearMonth , Year.


My PBI File :-

Paul Yeo

Super User
Super User

@Paulyeo11 , Create a calendar table join it with Invoice Date.

Watch my video:


or refer links

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :

See if my webinar on Time Intelligence can help:

Appreciate your Kudos.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Impactful Individual
Impactful Individual

Hi Sir


thank you for sharing.


I have watch your video from you tube and webinar.


may I know if I need to compute YTD sales not Qty . In your webinar is explain YTD QTY.

So to convert your expression to YTD sales I need to replace Qty to sales right ? 

i notice that you have list of expression , can you share the list to us ?



Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!