I have been fighting this issue for 2 weeks now, using a different approach that didn't work. This solution is elegant and brilliant, thank you!!
@MrSpiritUAll3 жыл бұрын
I love DAX Fridays on thursdays! Feels like living in the future. 👍 Btw a smooth intro. 🥳✨🥰
@CurbalEN3 жыл бұрын
😂😂😂
@vineetyoutubr53 жыл бұрын
Hey Ruth, thanks for making our life easier 😁 this was really useful as always.
@rogervandecraen97973 жыл бұрын
great video ! and helpfull, I'm wondering how to implement this when the allocation is not lineair but more seasonal , say that a group of products is significanlly more produced in Qtr 4 than in Qtr 1 2 & 3 for building an inventory? thanks in advance
@barttrudeau92373 жыл бұрын
Hi Ruth, Thank you for more great insights! I tried finding the PBIX file in the download site under DAX Fridays and cannot find it. Am I looking in the wrong place?
@waldof863 жыл бұрын
I've done similar calculations on SQL before and I have to say it's pretty nice how DAX handles it
@danielsiffredi84033 жыл бұрын
would it very nice to have that calculation leveraging working days instead of all days ;)
@CurbalEN3 жыл бұрын
Yes, it would, but something has to be left for you to chew on ;)
@danielsiffredi84033 жыл бұрын
Done ! Wasn’t that difficult to be honest. I was kind of stuck with the main allocation thought process. Thanks Ruth !
@CurbalEN3 жыл бұрын
Well done! 👏👏
@jaimeandrade66653 жыл бұрын
Thanks, congratulations😉
@pk51343 жыл бұрын
Hi Ruth, your videos are excellent and I have learnt a great deal from them! But sometimes the inset video of you covers what you are clicking on. Would it be possible to change that ? It will make it easier for people who are just starting out and not very familiar with the UI
@CurbalEN3 жыл бұрын
I got it now! Yes, I try to move myself around, but sometimes i miss some parts and i might block the UI. Will try to do better :)
@walidhome44842 ай бұрын
that a great thanks
@justinogarcia37053 жыл бұрын
It’s dax Thursday
@CurbalEN3 жыл бұрын
Yey!! Confusing eh? 😂😂
@kalinduSekara3 жыл бұрын
❤
@lanzino Жыл бұрын
Those tableau LODs are badly missed
@justinogarcia37053 жыл бұрын
Dax Thursday?
@CurbalEN3 жыл бұрын
Same series, different day ;)
@philipmorgan23023 жыл бұрын
The Expression refers to multiple columns. Multiple Columns cannot be converted to a scalar value.......hmmmmm?
@CurbalEN3 жыл бұрын
You are getting a table back when a number is expected. Now I wonder...did I add my sample file into the download center? I will check tomorrow.
@philipmorgan23023 жыл бұрын
i did not add a table durrrrr
@CurbalEN3 жыл бұрын
Vertipaq disagrees with you , I am afraid!
@philipmorgan23023 жыл бұрын
@@CurbalEN Hi. Too much haste. I watched the video again and missed the very first step. "Add a table". I just added the measure straight off. rookie error ;) Working now