Using EXPAND and COLLAPSE in visual calculations

See when EXPAND and COLLAPSE are required to obtain the correct result with visual calculations in Power BI.
Article and download: sql.bi/833902?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@zoranmilokanovic6229]

I don't know why, but I can't imagine a PBI developer (business user, self-service BI), who is not capable of writing a model measure for an inflation corrector, would write it as a visualization calculation. Am I the only one? 🙄 Kudos to Alberto for a great video.

[@chrismettler136]

I like the naming of the old-school measures as ‘modern’ measures.

[@mnowako]

It’s quite complex but incredibly useful. Well done as always. Thank you!

[@mtavassoti]

Great video 👍 Thanks a lot. (Enjoy DAX is so sarcastic 😂)

[@akhilannan]

I noticed that when referencing a column within a visual calculation, the table name is omitted in your code. Is this approach considered a best practice for visual calculations?

[@SQLBI]

Unfortunately, yes. Columns in visual calcs have no table name, because they are columns of the visual.

[@MDevion]

Visual calculations are horrible. I rather write MDX.

[@Negi_From_Pauri]

Bro you looks like Eminem rapper