Power BI

Data Modelling and optimization in PowerBI

What is Data Modelling? Data modelling is nothing but Entity-relationship diagrams that are used for better understanding of databases. If the relationship between the tables is not correct then the interaction between the visuals in Power BI will be wrong. So one needs to ensure the data model is correct when building dashboards. In PowerBI …

Data Modelling and optimization in PowerBI Read More »

SQL equivalent Power BI DAX functions – Part 2

Introduction In this article, we are going to see window function in SQL and its equivalent Power BI DAX function.If you want to check out SQL basic, check it out in part 1. Specifications Data – Loan transaction data Environment – Postgres and Power BI What is window function? A window function performs an aggregate calculation across …

SQL equivalent Power BI DAX functions – Part 2 Read More »