Sachin Nandanwarwww.azureguru.net·Dec 21, 2024Curious case of context transition in DAXIts been a quite some time that I haven’t blogged on Power BI DAX. So finally decided to pen down a very important and one of the most misunderstood concept in Power BI DAX called Context Transition. When it comes to row evaluation in Power BI DAX, t...PowerBI
Sachin Nandanwarwww.azureguru.net·Nov 8, 2024Dynamic Ranking with field parameters in DAXRecently on Microsoft Fabric PowerBI forum I came across one of a kind requirement which was a first for me. The original poster wanted dynamic rankings based on field parameters. I am familiar with dynamically adjusting the rankings based on slicer ...28 readsPowerBI
Sandeep Pawarfabric.guru·Nov 1, 2024DAX Parser AppThe power of open-source and GenAI. Klaus Jürgen Folz recently open-sourced the PyDAX library, which parses DAX expressions to extract or remove comments, and identify referenced columns and measures. I used that library to create some demos for myse...540 readsdax parser
Nalaka Wanniarachchibidiaries.com·Oct 21, 2024Bringing Your Power BI Dashboards to Life with Blinking IndicatorsHey there, data enthusiasts! Ever felt like your Power BI dashboards could use a little more... pizzazz? Well, what if I told you that you could add eye-catching, attention-grabbing blinking indicators to your reports? That's right – you can make you...40 readsPowerBIPowerBI
Nalaka Wanniarachchibidiaries.com·Oct 18, 2024The Auto Exist Conundrum: Unraveling DAX MysteriesHey there, data enthusiasts! Today, we're diving into a cool feature in Power BI that doesn't get enough love: DAX's Auto-Exist. Plus, we'll check out the new Value Filter Behavior that's giving us even more control over our data. Buckle up, because ...39 readsDAXdax
esProc Desktopesproc-desktop.hashnode.dev·Oct 16, 2024#75 - Find out The Intervals in Which A Certain Condition Occurs ContinuouslyProblem description & analysis: We have a statistical table for daily sales: Task: Find out the date when the sales rises for three consecutive days or more. Solution: Use SPL XLL and enter the following code: A 1 =0 2 =E(‘A1:B32’).group@o(if(Sales...excel
Vaibhav Zmasteringpbi.hashnode.dev·Oct 10, 2024Learn Power BI Cost-Effectively: Budget-Friendly TipsIntroduction to Mastering Power BI on a Budget In today's data-driven world, the ability to quickly analyze and visualize information is crucial for making informed decisions. Power BI, Microsoft’s flagship business intelligence tool, offers powerful...PowerBI
Nalaka Wanniarachchibidiaries.com·Oct 1, 2024How to Show Active Filters in Power BI Using DAX (One Method Among Many)Power BI reports often require users to apply various filters to explore the data in specific ways. But once those filters are applied, it’s helpful to show the active filters on the report, allowing users to understand exactly what data they’re seei...26 readsDAXdax
Sachin Nandanwarwww.azureguru.net·Sep 18, 2024ABS & REL parameters in DAX Window functionThe recently introduced Window function in DAX have made life easier when dealing with complex calculations especially that requires calculating running totals, ranking, and dynamic windowed aggregations across different contexts and partitions. I am...dax
Nalaka Wanniarachchibidiaries.com·Sep 18, 2024Comparing Sales Over the Same Date Range for Multiple Years in Power BIIn Power BI, one common need is to compare sales over the same date range across multiple years. For example, analyzing sales from January 1 to January 5 across 2018, 2019, and 2020, etc.. can provide valuable insights. Achieving this is easy with a ...32 readsPowerBIPowerBI