Machine learning in Power BI is a powerful tool for businesses looking to gain insights from their data. Power BI is a business intelligence platform that allows users to connect to a variety of data sources, create interactive visualizations, and share those visualizations with others. With the addition of machine learning capabilities, Power BI now […]
Let’s get started To convert FactInternetSales to Direct Query we will need to remove any transformations that are not supported in Direct Query mode. The FactIntenertSales has incremental Refresh Policy set up; therefore we need to delete all partition and create a new one. We will use Tabular Editor to help with this task. Please […]
Calculate is the mother function of DAX. I use Calculate almost everyday in 90% my DAX measures. With the latest update to the calculate using Or and ability use MAX and measures with aggregation as filters. The update of the semantic comes with a hidden filter. Look at the measure below Measure :=CALCULATE ( SUM ( Sales[SalesAmount] ), Product[Category] = “Bike” ) Above measure is […]
SCD Type 2 Fact tables are rarely used and often are not talked about. Lately, I was introduced to the concept and I was able to decipher this mystery. In the case business logic is to give a report to the business at the end of the month based on a snap shot of how […]
One of my favorite items in the March 2021 Power bi release is the update to the calculate function. Now we can use the OR Operator inside the CALCULATE function with out the need of calling the filter function within it.Below code shows an example of how we used to apply the OR Operator within […]
This would be useful for companies that are using PBIRS (On Premises Power bi reporting services). The world is migrating to the cloud but there is no shame if your company for a reason or two are still debating to migrate to the cloud. This article is tailored to overcome the export feature in the […]
Your model is most important step in creating and easy yet simple way for end users to either self service or for other developers to create reports and dashboards. I know you are here because you want to create the perfect product to impress your users. Well, you are in the right place, if you […]