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 »
Introduction Data Analysis Expressions (DAX) is used to compute the data in the power BI. DAX can be used to create measure as well as calculated column. It is not a programming language; it is a formula as well as query language. If you unleash the power of DAX, then you can become a power
Mostly used 15 DAX functions in power BI Read More »
