Power BI

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 »

SQL equivalent Power BI DAX functions – Part 1

Introduction SQL is the most widely used language for reporting or querying any historic data. In this article, I am going to explain how to convert SQL functions to Power BI DAX. SQL has many functions, so I explain the aggregate and non-aggregate function in part one.  Some other functions are explained in my upcoming article. …

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