Quick Measures in Power BI: You don’t have to write DAX!?

You read it right, you don’t have to write DAX. If you are calculating a year to date, running total, or every rolling average, you may be able to do it without writing a single line of DAX code. How this is possible? With Quick Measures. Quick measures are an easy way to create DAX Read more about Quick Measures in Power BI: You don’t have to write DAX!?[…]

IF and Filter are Different! Be Careful (DAX)

DAX has many functions to write conditional expressions. For example you might want to calculate sum of sales amount for all “Red” products. you can achieve it by using SUMX or Calculate, and functions such as IF or Filter to write a conditional expression for product color to be equal to “Red”. At the first Read more about IF and Filter are Different! Be Careful (DAX)[…]