-
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…
-
Mastering Date Manipulations in Excel: Your Ultimate Guide
📊 Mastering Date Manipulations in Excel 📊 I just published an incredible article on how to handle and manipulate dates in Excel. If you’ve ever had trouble with date formulas, this article is for you. From calculating the start of the month to determining the week number within a month, this article covers everything you…
-
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…
-
Efficiently Organize Your Measures in Folders!
Have you ever struggled with moving a huge number of measures into a folder in Power BI? That’s a thing of the past with the new January 2025 release. Now you can move them all at once! Watch my video and learn how!
-
Line Chart with target line
Welcome to my first post in my page. I am eager to share with you a modificated SVG template that will keep the months even if you filter dates in Power Bi. This code was extracted from Kerry Kolosko and modified by me. Remember to replace [Month Date] with your Date parameter, ‘Calendar’ with your…
Jaralytics 