Currency conversion in DAX for Power BI and SSAS
Another interesting question that came up recently is how to do currency conversion in Power BI. My colleague Jeffrey Wang had a very neat solution... Read more
Category: DAX
Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!
Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data but this... Read more
Use calculated tables to show only used rows in dimensions
UPDATE: you can now use measures as filter of a slicer so this post is outdated, please read here for what the recommendation is today:... Read more
Dynamic data comparisons using disconnected slicers, TreatAs and inactive relationships
Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added... Read more
Use the Power BI quick calcs with your own date table
Just a quick one today on how you can use the Power BI quick calcs with you own date table. I have a very simple... Read more
Automatically apply filters to your report per user
This was an interesting case I did a while ago where they wanted to have a report that automatically provided a set of filters to... Read more