TREATAS function in dax is used to establish virtual relationship between two tables in Power BI model. We can use one or more than one columns for filtering the tables. Handling relationships is an essential aspect of any data modeling exercise. If done correctly, it can save a lot of time and effort. Though Power…
DATESYTD function is a time intelligence function in Power BI to handle year to date calculation. Time intelligence functions are very useful functions to handle time-related problems we don’t complex code to achieve results. It returns a table that contains a column of the dates for the year to date, in the current context For…
Power bi “if statement” is straightforward to implement in DAX. It works the same as if-else in SQL. The syntax of if statement in dax is IF(logical_test,value_if_true, value_if_false) The first parameter of if statement in power bi is any expression that can return true or false output. If the output of the logical_test is true,…
Power bi countif is not available in dax functions, but it is very intuitive to implement in DAX. To achieve countif in Power BI, we will use the COUNTROWS function. The syntax of the COUNTROWS function is COUNTROWS(<table>). It takes one parameter as a table and returns the count of all the rows in the…
Sumif power bi equivalent in dax can achieve in different ways. Unfortunately, there is no such function available in power bi dax. But it is not difficult to get the required result with the help of workarounds. In this article, I will try to implement power bi sumif with two compelling functions in dax that…
Calculate in Power BI is a powerful and magical function that performs essential functions. It is straightforward to learn but takes time to master. It changes the filter context partially and does the context transition. With the help of calculate in Power BI, we can add, ignore, or override the filter context. Let us learn…