Thanks #SQLBI@marcorus@FerrariAlberto
Took may/23 off to study hard again and finish Optimizing DAX v2 and SQLBI+ updated videos, ty so much!
time to digiest/review
BRegards
This article+video describes the possible rounding differences that can appear in DAX. They relate to the data types and the operation being performed: knowing these details helps you write more robust #dax formulas and avoid comparison errors.
#powerbi
https://t.co/ivDqtZa1ri
@CJMajka Exactly...you can see the sheets from the outside...each sheets as a line in a column...than promoteheaders to them all in a new column, if you need a post a real example
@PowerBIguy Its a complex topic...depends on what type analysis (usually week 53 and 1 are "useless") but the main go is understand is why weeks? First we go if it is to have 7 over 7 analysis? Than its will lead the other questions
@ChrisHamill17 @mohaali45 Already tryed debug feature in TE3?
Thinking now,could be a good idea, be able to change filter context in real time, during debug and it re-evaluate the variables, what do you think @marcorus ?
@marcorus At first I thought it would calculate all itens and than it would choose the selectedvalue after that...but after running in dax studio, saw diff behavior... could that be a first wave of "passing parameters" to other calculations? Or close to that in future?
@FerrariAlberto@marcorus Alberto we fell the same white creating dashboards and reading the articles...we try to ignore something and move on but later realize we went wrong lol ( @marcorus lets wait a few weeks hahaha )
@notaboutthecell@InsightsMachine@eric_beery11@GreyskullPBI@mim_djo If you want to get DP-500 certification, you must have experience with Tabular Editor, DAX Studio, and VertiPaq Analyzer.
I suppose it should be a requirement for many.
See page 3 of “skills measured” guide:
https://t.co/tJqUrbI0hL