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 »
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 »
Introduction In this article, I am going to explain how to convert the data connectivity from import mode to direct query mode. I got this trick in the powerbi community from a superuser. I applied this method to the powerbi dashboard where visual interactions are too complicated and it works fine. The condition needs to
Convert import mode to direct query in Power BI Read More »
