Calculation Groups Use Cases – Power BI Matrix In my previous post here I explained Calculation Groups and how to create them in SSAS. After that I have started exploring…
Category: SSAS
Calculation Group in SSAS 2019
What is Calculation Group Calculation group is a new DAX feature introduced in SSAS 2019 where it creates generic DAX formulas in the model and uses them for different measures…
Monitoring Azure SSAS Performance by Power BI
An important part of any data source system is monitoring when the admins can check the health of the system and be aware of consumption rate. In Azure Analysis Service…
Power BI Design Modes - Part 3 - Live Connection
Live Connection In this mode the model components and definitions such as tables,column’s attributes and datatypes, relationships, hierarchies, calculated tables and calculated columns are implemented in a semantic SSAS model…
Dynamic Partitioning in SSAS Tabular Using M Query
One feature that makes SSAS Tabular a good choice for handling the large datasets is table partitioning.Table partitioning allows a big table be split into multiple partitions based on values…
Date Custom Format in SSAS Tabular
Some days ago I been asked by a BI developer about how to set format of SSAS Tabular date column to dd/mm/yyyy in SSDT(Sql Server Data Tools). If you…