Week 52 vs Week 53 Potential Solution: Previous Week = VAR _CurrentWeek = SELECTEDVALUE('Date DIM'[WEEK_NO_ISO]) VAR _CurrentYear = SELECTEDVALUE('Date DIM'[YEAR_NO_ISO]) VAR _PreviousYear = _CurrentYear - 1 VAR _MaxWeekPY = CALCULATE( MAX('Date DIM'[WEEK_NO_ISO]), FILTER( ALL('Date DIM'), 'Date DIM'[YEAR_NO_ISO] = _PreviousYear ) ) VAR _TargetWeek = IF ( _CurrentWeek = 1, _MaxWeekPY, _CurrentWeek - 1 ) VAR _TargetYear = IF ( _CurrentWeek = 1, _PreviousYear, _CurrentYear ) VAR _Result = SUMX( FILTER( ALL('Date DIM'), 'Date DIM'[WEEK_NO_ISO] = _TargetWeek && 'Date DIM'[YEAR_NO_ISO] = _TargetYear ), [# OB Entries] ) RETURN _Result
@HanaShahКүн бұрын
Hi, I don't know why but when I create the PowerApp from Power BI, it doesn't fetch the data, and the PowerBIIntegration returns an empty collection. I used data from Databricks (DirectQuery)
@MatusiSKКүн бұрын
Amazing solution !! Thank you !
@archstand3 күн бұрын
Excellent content, as usual , Sam and team !!
@AngelicaIrwin5 күн бұрын
This video is super helpful! Thank you so much for sharing!
@gerot997 күн бұрын
How you make the second chart can looks like that, i search how to make chart like population pyramid, you not show how to do it 😢
@PhatNguyen-nm4dv8 күн бұрын
Why I can't add visuals from the app to Power BI desktop? Please help me
@Gangminhee-y7e9 күн бұрын
Hello SIr , i resimulate one paper result to isolation forest algorithm but i have face difficulties i just one question how can we find the anomly score of data in python(mean i dont know which function is use to find it)? you just predect which is normal and which one is outlier but i need the anomaly score value for my paper requirements kindly help me in this matter
@jesusvarela94479 күн бұрын
Thanks it help me a lot
@AkashYadav-rx2jc10 күн бұрын
Could show that with chart ?
@charotarguy110 күн бұрын
I want to add a column in a dataset table A . this column should be selected value from slicer ... how do i do this.. i am getting default value of slicer and not selected. ( slicer i have made from different table B which has no relationship. Table A is through sql query and B is made from constructor manual table A table b result table A ( should have belows two columns added) item code value percent item code value percent totalvalue x 10 5% x 10 7.5% 10*7.5% y 20 6% y 20 7.5% 20*7.5% z 35 7.5% z 35 7.5% 35*7.5% slicer is made of table B column of percent, and selected value of slicer is 7.5%........
@archstand13 күн бұрын
Great video, Sam ! Enterprise DNA Member here ! Could you let me know why we are using CALCULATETABLE , as opposed to SUMMARIZE etc. Thanks
@hishnick7913 күн бұрын
How would you handle 0sales on certain dates, the dax returns blank instead of previous running total.
@archstand14 күн бұрын
Brilliant video ! Cheers from an Enterprise DNA Pro member
@sleepyvoyager15 күн бұрын
Thank you. This is amazing.
@klabux16 күн бұрын
Thanks for the great tutorial and the easy to understand explanations.
@alexgazzaniga950817 күн бұрын
Guys, this may be 4 years old but it saved my reporting bacon today! Nice work.
@PaweKleszcz8917 күн бұрын
Hi, how can I download the data source ?
@maedehshoeib798617 күн бұрын
It was amazing thank you but i have a question Didn't you copy the netflix stock first? Then you made an excel naming it other stocks Would you please guide me 😢
@rolandasz318018 күн бұрын
I get error 404, when following the link.
@hoxton_heat19 күн бұрын
mailing isnt working there to try. confirmation blocks login page. langfuse is tool to go, no need to reinvent the wheel.
@reticulan22 күн бұрын
is there a way to refresh just one source instead of the whole dataset? cool video thanks!
@MargaretMartinez-j6t23 күн бұрын
Thanks for sharing such valuable information! A bit off-topic, but I wanted to ask: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How can I transfer them to Binance?
@saftheartist613723 күн бұрын
Brilliant! 👏
@Carolina-h3x3q24 күн бұрын
Hello! Is it possible to intersect more than 2 products at the same time?
@zxccxz16424 күн бұрын
not good. no discussion of performance.
@DemonicSalt25 күн бұрын
THANK YOU!! This was driving me insane.
@lenholder515425 күн бұрын
Good
@myexcelacademy6926 күн бұрын
Thank you, this helped me solve my issue. Exactly what I was looking for👍
@davidtuti128 күн бұрын
Thanks fory your video! Awesome! I need to create these way to see values beforte a date selected in a table. Do you have the file of the video? Could you share it? Thanks!
@tallswar29 күн бұрын
I like this kind of professional teacher 😍
@divyapreethi2609Ай бұрын
I can’t integrate my data to powerapps
@RatnakumarwritesАй бұрын
Can I add a column to it...? Say, Fiscal year starting month (Starting from 1)...?
@rapatel1642Ай бұрын
Smart.
@alexcastas8405Ай бұрын
This is such a good explanation and example, really appreciate it!
@lellasaikrishna8037Ай бұрын
Hi , Could you please post the dax expression used for the measure "Product", "Status", "Province", "Country", "Continent".
@evelicАй бұрын
Unclear to me
@matthewshotton86Ай бұрын
Love this idea - is there a way to have this ranking, but still show the values that blank? Thinking that in this solution you don't actually know if they're not a top 20 because of a shift in client sales, or if the client stopped ordering all together!
@fazilkiansАй бұрын
This is so cool. ❤
@aojsr9986Ай бұрын
You just gave me a life changing idea!!!!! Grab the template code from GitHub
@mistercloud8154Ай бұрын
Why when I click RUN, it failed. error said: Correlation Id: c1788350-7dc3-4f73-91e3-b056c9f2853b Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)). I use Ms Office 2021. Please help
@zxccxz164Ай бұрын
unclear how this works without a time element. avg xxxxx is extremely misleading. over what time frame? when was last? what meds could have brought it down.
@JulianOlarteJSАй бұрын
Dear Melissa, from Colombia, this video is powerfull and you are the best, thank you for your help!
@mieproductions6209Ай бұрын
What can you do if you only have 1 value but you still want to calculate the sub-total differently? In this case, both the subtotal has one value and the row/column context.
@cesarsaldana3429Ай бұрын
Amazing!!
@cardguysАй бұрын
Very close to what I want. How do you produce these results sliced at the month? Temporarily you had month as a slicer, then you selected a month, and your visual broke (6:36). How do you make this work so that the visuals don't break at the monthly grain?
@TomLaurensАй бұрын
The formula is returning once the customer is lost, a value for every month after the customer is lost. I just want to mark and count the customer as lost when it actually is lost, not in the period after. My data is now showing like i am losing a lot of customers each month, but in reality we already lost them in the past and not every month again. Hoe should i change the formula?
@AbhishjaАй бұрын
how to fix the provided hostname issue that could not resolved on Http?
@adegunloyerebecca2671Ай бұрын
@EnterpriseDNA Hello Coach, I recently discovered your course, and it truly captured my interest. The high-quality, specialized content aligns perfectly with what learners are looking for. I would be grateful for the chance to ask a few questions and gain valuable insights into the course. Any additional guidance you could provide would also be immensely appreciated. If you’re available for a brief conversation, please let me know. Thank you, and congratulations on your excellent work! Best regards, Flora