Let's get started Fact Internet Sales table is in Import Storage mode. 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...
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...
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...
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...
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...
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...