I just manage import a sales table to PBI.
Can some one advise me how to add master claendar m so that i can get Qtr , YearMonth , Year.
My PBI File :-
@Paulyeo11 , Create a calendar table join it with Invoice Date.
Watch my video: https://www.youtube.com/watch?v=Qt0TM-4H09U
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 : https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions https://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...Appreciate your Kudos.
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 ?
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.