Topic: DAX

       Page 4 of 191 blog posts
blog post –

Avoid measure and column with the same name in #dax

I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and  Read more

blog post –

Unexpected side effects of table filters in #dax

One of the side effects that you might not expect from a table filter in a CALCULATE statement is the removal of an existing filter. In reality, this is a condition that happens when you write an explicit CALCULATE in a row context, because the table  Read more

blog post –

Mark as Date table in Power BI #dax #powerbi

One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI (I just updated the article including the example described below). In a recent event in Sydney I observed a strange (or at least unexpected) behavior  Read more

blog post –

Format measures as dates in Power BI #dax #powerbi

If you want to format a measure as date in Power BI, you need an expression returning a date/time data type. This is different from what you can do in Power Pivot and in SSAS Tabular, where you can format any numeric expression using a date and/or time  Read more