Using variables to split up your calculations
Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do... Read more
All about Power BI, Modelling, DAX and Microsoft BI
Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do... Read more
Got an interesting question recently where someone wanted to be able to switch the relationships automatically based on which slicer was selected. Take the following... Read more
Usually I start my blog posts with an interesting question I got, this time we will do the reverse. I want to talk about a... Read more
A common questions I get is to change the connection string to from my report to SSAS after I move my Power BI desktop file... Read more
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
Another Power BI embedded blog post while I have a playground up and running. Often when you want to use SSAS with Power BI embedded... Read more
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
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