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 ...DiscussPowerBI
Sandeep PawarProfabric.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...Discuss·481 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...Discuss·34 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 ...Discuss·35 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...Discussexcel
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...DiscussPowerBI
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...DiscussDAXdax
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...Discussdax
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 ...DiscussPowerBIPowerBI
Nalaka Wanniarachchibidiaries.com·Sep 18, 2024Power BI Tip: Creating Dynamic Tooltips Using CONCATENATEX DAX FunctionTooltips in Power BI are often overlooked but are a powerful feature that can deliver detailed information at a glance. By default, tooltips show basic data related to the visual element being hovered over. However, when working with complex datasets...DiscussDAXPowerBI
