If you want to compare the sales up to a particular day and compare it with the previous period (month, quarter, or year) but up to that particular day in that period, then it is called previous month-to-date, previous quarter-to-date, and previous year-to-date. These calculations can be more helpful than comparing with the entire period last month because if this month is still not full, then comparing with a full period won't give you a close comparison point. In this article and video, I'll show you how you can calculate these using DAX in Power BI.
Find the links to study more in my article here:
[ Ссылка ]
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: [ Ссылка ]
Our upcoming courses: [ Ссылка ]
Free books and tools for Power BI: [ Ссылка ]
Power BI Helper: [ Ссылка ]
Become an academy member: [ Ссылка ]
*******************
********
CONNECT with US!
********
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
-- [ Ссылка ]
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD
