Skip to content

Kloudspro

  • Home
  • Quick Links
    • Microsoft Certifications
    • Azure Portal
    • Azure Data Factory
    • Power BI Service
    • Azure Data Centers
    • Azure Pricing Calculator
    • Azure Database Migration Guide
    • Microsoft Bug Bounty Program
    • Databricks Community Edition

Tag: dax

One Catch in DAX Formatter

January 10, 2021 Parry M.

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

Continue reading

Use COUNTROWS instead of COUNT

August 22, 2020 Parry M.

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

Continue reading

Best Practice to Deal with BLANK in Power BI

August 22, 2020 Parry M.

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

Continue reading

Count(), CountA(), CountRows() and CountX() Functions

June 17, 2020 Parry M.

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

Continue reading

Calendar vs. CalendarAuto

June 17, 2020 Parry M.

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

Continue reading

An Introduction to DAX

June 11, 2020 Parry M.

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

Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Search what you are looking for

Read this blog in your own language

Advertisements
  • Home
  • Quick Links
Create a website or blog at WordPress.com