Creating Custom Table in SSAS Tabular using Table and Row Constructors in DAX
A while ago I was working on a Power BI project which the customer wanted to define a new table…
Archive
Category: DAX
Using “IN” Operator in DAX
If you are a SQL guy I bet you’ve used “IN” operator zillions of times. You might also looked for…
How to Overcome Map Related Issues in Power BI, Power View and Power Map
One of the most powerful features in Power BI and Excel is supporting geospatial visualisations. In Excel we can use…
Connect to Power BI Desktop Model via its Local Port from Excel and SSMS
Power BI Desktop is a fantastic report authoring tool. I have lots of experience working with Tableau as well and…