While we always recommend to develop the habits of writing clean and well formatted code as part of best programming practices but if there have
Tag: dax
Use COUNTROWS instead of COUNT
Both COUNT() and COUNTROWS() functions accepts single parameter. The difference lies in the fact that COUNT() operates over a column whereas COUNTROWS() asks for the
Best Practice to Deal with BLANK in Power BI
Measure definitions where BLANKs are converted into some default or alternate values are generally considered as poor design because they are not efficient. When measures
Count(), CountA(), CountRows() and CountX() Functions
Both Count() and CountA() functions counts non-blank values but works with different data types. Count() = works with Numbers, Dates and String data types only
Calendar vs. CalendarAuto
Calendar() and CalendarAuto(), both functions help you to create a base table for date dimension. They give you a contiguous set of dates which is
An Introduction to DAX
DAX stands for Data Analytical Expressions. This is a language in itself that can be leveraged to do all analytical calculations, be it regular aggregations