Tag: Power Query
-
Excel – Cube formulas
Knowing This Literally Saved My Job Let me tell you a little secret that not many Excel users know—one that might just change how you build reports forever. The CUBE formulas family in Excel is a hidden gem. They’re rarely used, barely talked about, and yet incredibly powerful. Why? Because they allow you to pull…
-
Extract All Dates Within a Date Range Using Power BI
Have you ever wondered how to move from this To this: If so, this is the right post for you! This process is replicable in Power BI. Here’s a step-by-step guide to help you extract all dates within a date range. Congratulations! You have successfully extracted all dates within the range. Now, you can clean…
Jaralytics 