topic Re: DAX/Vertipaq insights in DAX Commands and Tips

DAX/Vertipaq insights

ppvinsights — Mon, 27 Apr 2020 05:13:53 GMT

Hi Community,
Having a lot expirience in using DAX but I lack a more deeper understanding of the underlying engine.
Just an example:
Shall I use Crossjoin or nested sumx?

I Do Not want to have an answer for this specific question. I am looking for books/Videos to solve this question myself. Any Suggestion?
Thanks a lot and stay healthy!
Holger

Re: DAX/Vertipaq insights

Anonymous — Mon, 27 Apr 2020 05:31:29 GMT

ppvinsights ,

Please check these to understand more about Veripaq.

https://www.sqlbi.com/tools/vertipaq-analyzer/

https://www.youtube.com/watch?v=m34IOHcNPPo

https://www.youtube.com/watch?v=b8oSgTOeYCE

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

Re: DAX/Vertipaq insights

ppvinsights — Mon, 27 Apr 2020 06:59:25 GMT

Hi Harsh Nathani,

thank you for your answer. I know all that stuff - it is more about how to keep your dataset small.

But when it comes to "which one is faster: crossjoin ort nested sumx" this is not a help for me 😞

Any other suggestions? I think the query plan of daxstudio is probably the right way - but I do not understand anything when I look at the query plan...

Thanks

Holger

Re: DAX/Vertipaq insights

ppvinsights — Mon, 27 Apr 2020 07:45:27 GMT

Sorry, after posting the last reply and mention "daxstudio" and "queryplan" I googled for specific documentation - and found this docs:

https://daxstudio.org/documentation/videos/

I think this is what I was looking for. Sorry - google was my friend 🙂