Why not a date and time table in Power BI instead?

Convert rows to columns using Power Query – Excel and Power BI

If you get data in a single column with multiple records, you can easily convert it to multiple columns using Power Query. Watch and Try with ...

D3: Highest average discount | #25daysofdaxfridays challenge

Microsoft Fabric EXPERT Reveals Top Data Analytics Techniques for 2025 | Fabric or Power Bi | Taik18

SWITCH between TIME SLICERS in Power BI

D2: Products with the highest order size | #25daysofdaxfridays challenge

Creating [DAX] SVG Charts using Chat GPT!

STOP Writing DAX: Microsoft Copilot Does It Better!

D1: Product most ordered | #25daysofdaxfridays challenge

Computing open orders with visual calculations in DAX

Taking MAPS in Power BI to the next level