Power Query Transformation Pattern Convert Status Log Dates Table to Start and End Date Table in P

Описание: I have previously explained how to analyze the data of a status log table and a from/to date table (like a subscription pattern). I also explained that in some scenarios a from/to table works better than a status log table. In this article and video, I’ll explain how you can transform or convert a status log table into a from/to or start/end table using Power Query in Power BI.
Learn more from my blog article here:
https://radacad.com/power-query-trans...

*******************

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: https://radacad.academy
Our upcoming courses: https://learn.radacad.com/events/
Free books and tools for Power BI: https://radacad.com
Power BI Helper: https://powerbihelper.org/
Become an academy member: https://learn.radacad.com/academy/

*******************

********
CONNECT with US!
********

--   / radacad_com  
--   / rad_reza  
--   / leila_etaati  
--   / radacad  
--   / leila-etaati-b0304636  
--   / rezarad  
--   / 6393399  
-- https://radacad.com

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD