This category references all article related to analysis services tabular version. This include TOM libraries, Dax and security and more.
When loading data into Power BI, it is often necessary to convert date columns to datetime columns. This is because Power BI uses datetime columns for its internal data storage for incremental load. There are a number of ways to convert date columns to datetime columns in M code. One way is to use the […]
In data warehousing, two main approaches to data modeling are Tabular and Multidimensional Cube. Each method has its own strengths and weaknesses, and the decision on which to use depends on the needs of the business. Tabular models are built on the relational database model and use the DAX (Data Analysis Expressions) language for calculations […]
In dimensional modeling, there are two main schema designs: Snowflake and Star. Each has its unique advantages and use cases, and the decision to use one over the other depends on the data and the requirements of the business. Snowflake schema is a normalized design that separates data into multiple related tables. This schema is […]
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 […]
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 […]