Using EXPAND and COLLAPSE in visual calculations

preview_player
Показать описание
See when EXPAND and COLLAPSE are required to obtain the correct result with visual calculations in Power BI.

Рекомендации по теме
Комментарии
Автор

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.

zoranmilokanovic
Автор

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

mnowako
Автор

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

chrismettler
Автор

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

mtavassoti
Автор

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?

akhilannan
Автор

Visual calculations are horrible. I rather write MDX.

MDevion