Easy Technique for Improving DAX Measure Testing
Рет қаралды 1,333
Күн бұрын
@JohnSpanos 3 жыл бұрын
Been writing it the way for years and it makes so much more sense. If only dax formatter would add this as an option!
@olemew Жыл бұрын
Dax studio 3.0.0 includes this feature!!
@mcnater 3 жыл бұрын
this is exactly how I've written long SQL queries for years as well. Makes so much more sense. Never understood commas at the end.
@HavensConsulting 3 жыл бұрын
It really works so well for commenting :)
@DanielWeikert 3 жыл бұрын
Is there actually a way in Power BI to delete all unused measures? The warning which appears for each measure regardless whether it's used or not is not really helpful.
@HavensConsulting 3 жыл бұрын
Tabular Editor has a feature to show "unused measures" :)
@DanielWeikert 3 жыл бұрын
@@HavensConsulting Thanks is there a video showing this?
@HavensConsulting 3 жыл бұрын
@@DanielWeikert I don't have a video showing this. But Tabular Editor has an entire documentation page dedicated to this. :) docs.tabulareditor.com/Best-Practice-Analyzer.html
@DanielWeikert 3 жыл бұрын
@@HavensConsulting Thanks have to check. The best practice rules from github I have used before but was not aware there is an option to remove the unused measures as well
@HavensConsulting 3 жыл бұрын
@@DanielWeikert yup! It shows unused measures/columns. You can use the code to remove it. Though I typically delete a batch at a time, then check the model to see if there was any breaking changes.
@BernatAgulloRosello 3 жыл бұрын
I like comas at the beginning, but I think dax formatter puts them at the end of each line. It would be nice to toggle that somewhere in dax studio
@HavensConsulting 3 жыл бұрын
I agree! I should make a tweet about this I think
Adam Finer - Learn BI Online
Рет қаралды 100 М.
Harley Quinn with the Joker
Рет қаралды 23 МЛН
Leila Gharani
Рет қаралды 827 М.
Havens Consulting
Рет қаралды 2 М.
😍 Таких шикарных и гибких телевизоров, тем более за такую копеечную цену вы больше нигде не найдете.
Любимый WB
Рет қаралды 5 МЛН
Павел Хмурчик
Рет қаралды 590 М.
Trendy Tech Review Show
Рет қаралды 14 МЛН