My Power BI workflow for 2024.....
20:49
Next Level Field Parameters
36:14
8 ай бұрын
CALCULATE Deep Dive
1:03:43
9 ай бұрын
Everything About Power BI Security
45:42
Rethinking Dashboard Design
38:13
9 ай бұрын
Пікірлер
@prashantibijapur6913
@prashantibijapur6913 21 сағат бұрын
Cannot see the download option anymore
@mureedabdullah3444
@mureedabdullah3444 Күн бұрын
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
@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
@MatusiSK Күн бұрын
Amazing solution !! Thank you !
@archstand
@archstand 3 күн бұрын
Excellent content, as usual , Sam and team !!
@AngelicaIrwin
@AngelicaIrwin 5 күн бұрын
This video is super helpful! Thank you so much for sharing!
@gerot99
@gerot99 7 күн бұрын
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-nm4dv
@PhatNguyen-nm4dv 8 күн бұрын
Why I can't add visuals from the app to Power BI desktop? Please help me
@Gangminhee-y7e
@Gangminhee-y7e 9 күн бұрын
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
@jesusvarela9447
@jesusvarela9447 9 күн бұрын
Thanks it help me a lot
@AkashYadav-rx2jc
@AkashYadav-rx2jc 10 күн бұрын
Could show that with chart ?
@charotarguy1
@charotarguy1 10 күн бұрын
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%........
@archstand
@archstand 13 күн бұрын
Great video, Sam ! Enterprise DNA Member here ! Could you let me know why we are using CALCULATETABLE , as opposed to SUMMARIZE etc. Thanks
@hishnick79
@hishnick79 13 күн бұрын
How would you handle 0sales on certain dates, the dax returns blank instead of previous running total.
@archstand
@archstand 14 күн бұрын
Brilliant video ! Cheers from an Enterprise DNA Pro member
@sleepyvoyager
@sleepyvoyager 15 күн бұрын
Thank you. This is amazing.
@klabux
@klabux 16 күн бұрын
Thanks for the great tutorial and the easy to understand explanations.
@alexgazzaniga9508
@alexgazzaniga9508 17 күн бұрын
Guys, this may be 4 years old but it saved my reporting bacon today! Nice work.
@PaweKleszcz89
@PaweKleszcz89 17 күн бұрын
Hi, how can I download the data source ?
@maedehshoeib7986
@maedehshoeib7986 17 күн бұрын
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 😢
@rolandasz3180
@rolandasz3180 18 күн бұрын
I get error 404, when following the link.
@hoxton_heat
@hoxton_heat 19 күн бұрын
mailing isnt working there to try. confirmation blocks login page. langfuse is tool to go, no need to reinvent the wheel.
@reticulan
@reticulan 22 күн бұрын
is there a way to refresh just one source instead of the whole dataset? cool video thanks!
@MargaretMartinez-j6t
@MargaretMartinez-j6t 23 күн бұрын
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?
@saftheartist6137
@saftheartist6137 23 күн бұрын
Brilliant! 👏
@Carolina-h3x3q
@Carolina-h3x3q 24 күн бұрын
Hello! Is it possible to intersect more than 2 products at the same time?
@zxccxz164
@zxccxz164 24 күн бұрын
not good. no discussion of performance.
@DemonicSalt
@DemonicSalt 25 күн бұрын
THANK YOU!! This was driving me insane.
@lenholder5154
@lenholder5154 25 күн бұрын
Good
@myexcelacademy69
@myexcelacademy69 26 күн бұрын
Thank you, this helped me solve my issue. Exactly what I was looking for👍
@davidtuti1
@davidtuti1 28 күн бұрын
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!
@tallswar
@tallswar 29 күн бұрын
I like this kind of professional teacher 😍
@divyapreethi2609
@divyapreethi2609 Ай бұрын
I can’t integrate my data to powerapps
@Ratnakumarwrites
@Ratnakumarwrites Ай бұрын
Can I add a column to it...? Say, Fiscal year starting month (Starting from 1)...?
@rapatel1642
@rapatel1642 Ай бұрын
Smart.
@alexcastas8405
@alexcastas8405 Ай бұрын
This is such a good explanation and example, really appreciate it!
@lellasaikrishna8037
@lellasaikrishna8037 Ай бұрын
Hi , Could you please post the dax expression used for the measure "Product", "Status", "Province", "Country", "Continent".
@evelic
@evelic Ай бұрын
Unclear to me
@matthewshotton86
@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
@fazilkians Ай бұрын
This is so cool. ❤
@aojsr9986
@aojsr9986 Ай бұрын
You just gave me a life changing idea!!!!! Grab the template code from GitHub
@mistercloud8154
@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
@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
@JulianOlarteJS Ай бұрын
Dear Melissa, from Colombia, this video is powerfull and you are the best, thank you for your help!
@mieproductions6209
@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
@cesarsaldana3429 Ай бұрын
Amazing!!
@cardguys
@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
@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
@Abhishja Ай бұрын
how to fix the provided hostname issue that could not resolved on Http?
@adegunloyerebecca2671
@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