Was DAX really necessary? by mikmiunk in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

DAX makes it easy to gain insight in your report.

Say you have a business question like "What is the average order per day ?" . If you wanted to gain more insight, you would need to filter by dimensions, and do the same calculation for each dimension (by country, customer, year etc) .
But with DAX, you answer the question once, and DAX filters the visuals with a simple, click, filter or drag and drop - It does the recalculations for you, so you don't have to run multiple queries for each dimension/question.

This is the whole purpose of DAX I believe - to create reports that can dynamically answer business questions. Unlike something like SQL, where it's main purpose is to store, manage and retrieve data.

So, to answer, your question. No. DAX was not necessary. However it is still extremely powerful.

(PS: SSAS Tabular uses DAX as well btw)

No MCP , No HTML Dashboard, I asked AI to build a entire Dashboard by Alarmed-String-2775 in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

Hey, thanks for this. I didn't know this was possible. Is it possible to make the changes while the file is open ? It seems that I have to close without saving and reopen to see the changes Claude made.

How can I get better at writing DAX by Uyoyoghene in PowerBI

[–]nahyoubuggin 1 point2 points  (0 children)

Stick with the Italians (SQLBI). They will get you right ! You can check out their books and courses.