Tag: Power BI
Posted in Power BI
Power BI – Issue in using Query List Parameter (Query references other queries or steps)
I had a business requirement where I need to get the list of Products Ids in scope from an Excel file provided by the business…
Posted in Power BI
Power BI – Parent-child Hierarchies in DAX
As part of my project activities, I sometimes have to deal with parent-child hierarchies and need to flatten them in Power BI. A common parent-child…
Posted in Power BI
Power BI – PATH function for Parent-child Hierarchies in DAX
We sometimes have to deal with parent-child hierarchies and need to flatten them in Power BI. A common parent-child scenario is Geography where we have…
Posted in Power BI
Power BI – TOTALYTD DAX Time Intelligence Function
What is TOTALYTD function? Let us consider a scenario where you are working on a report in Power BI where you need to calculate the…