Видео

How seaborn take diamond data in Power BI ? Where you uploaded your dataset

This is cool but would be nice to be able to add a second dimension field. For example, show me the top 10 customers by quarter and then allow me to drill down into the products they purchased. This formula does not work for that 😢

Thanks is there a best practice for extracting all columns from a record without hard coding names?

This is exactly what I need when my IT department lets me out of my Personal Productivity environment. Bookmarking this.

Customers LTD = VAR CustomersLTD = CALCULATE( DISTINCTCOUNT(Sales[CustomerKey]), DATESBETWEEN( 'Date'[Date], BLANK(), MAX('Date'[Date]) ), 'Sales Order'[Channel] = "Internet" ) RETURN CustomersLTD New Customers = VAR CustomersLTD = CALCULATE( DISTINCTCOUNT(Sales[CustomerKey]), DATESBETWEEN( 'Date'[Date], BLANK(), MAX('Date'[Date]) ), 'Sales Order'[Channel] = "Internet" ) VAR CustomersPrior = CALCULATE( DISTINCTCOUNT(Sales[CustomerKey]), DATESBETWEEN( 'Date'[Date], BLANK(), MIN('Date'[Date]) - 1 ), 'Sales Order'[Channel] = "Internet" ) RETURN CustomersLTD - CustomersPrior

does this solution work for matrix as well?

Good Day Where can I get access to this coarse content

Hi, can I get ur mail id Also please share the raw pbi file to apply changes.

I am using on multiple measures using selectedmeasureName() instead of one in Calculation group function...but it is not working. Could you please suggest how to do this.

Thanks for the video, but why didn't you add the file???

First report is one of the worst reports I have ever seen. Design is trash. Whole series of reports is also trash tbf

Great tutorial but can you elaborate more on the fail condition please? I accidentally left the loop running and got billed significant amount on the api usage

Is there a way to use what was harvested from the slicer to be used as a condition in an IF statement?

Simple measure that saves loads of time! Thank you!

I was hoping you would have shared your JSON code sample in the description area.

Stepped layout option is now under Layout and Style Presets > Layout > Tabular

Can you elaborate more on the fail condition please because it is working for me but I am getting the trimmed email sent mulitple times. Thanks!

Thank you so much! I was able to use this example in a few different areas.

Excellent !

Would be cool if it was more accessible

I'm curious if you can use part of a file name to rename the entire file name. So if the name was "Enterprise DNA - PowerAutomate" could you set a parameter/variable to find the powerautomate as the keyword, and rename the whole file to be PowerAutomate-Tutorial.

I was big on DAX but now shifted my focus towards python.

Thank you so much sir, it was really helpful

Is that Power BI alone? Are you integrating it with something else?

This video really helped thank you very much. It's helped me copy a ton of Dax measures into the same report for a different group, which has saved me so much time.

Outstanding what any AI can do these days. I'd like to see more of these type of videos from Sam.

Thank you very much, I searched for several hours to find out how to highlight the last date, and even ChatGPT and Copilot failed to help me :). Thank you very much for this still relevant video!

Surprised so few have liked this video and commented on it Brilliant analysis

Would be great if the vid has annotations tagged to it

Thanks very much for this!

very useful. Thanks

I like it but unfortunately there is no free version nor accessible. 550USD per year (no monthly payment available). That's harsh.

Like #69! I'll take it. Lucky numbers.. TY for this. Time saver for sure

great video!!! thank you. only small issue that is very quick. does enterprise has got any course regarding CALCULATE ?

I'm trying to download the data for the tutorial but the webpage is not opening showing error 404. Pls look into it.

One of the pathetic channel... posting content to charge money.... You should tell at very beginning that the resources are chargeable...

Here are the prompts he used: 1 Can you act as a data analyst and evaluate this dataset. Also, can you help me understand what the data structure is and what I could analyze from it [insert or paste data] 2: I am a complete novice in Power BI can you help me get this data into Power BI and walk me through step by step how to using Power Query editor to clean up the data 3: What transformations within Power Query should I be aiming for. Can you give me a solid example that will make my data more optimized? 4. Can you act as a data modeling expert and develope a well defined data model for me in Power BI on the data I provided above 5.Can you create my core measures for me for my Power BI analysis and use only SUM,AVERAGE, COUNTROWS, MIN, MAX DAX functions 6. Can you please now create my key measures using iterating functions like: SUMX, AVERAGEX, MINX, MAXX 7.can you give me a range of best practices around power bi visualization and Report development 8. Can you act as a storytelling and visualization expert and help me develop a report for my executive team on the data provided above can you advise me on where to place each Visual and also which is the best visual to showcase the main insights

Great video. Thanks

hi can have your email, i have a questing if you could help me?

Those visuals...

2:32- Hi Sam, what about if you want to say "if there's a 'no' in 'Inspect?' column, show "don't inspect" in the EVENT column. If the 'Inspect?' column is blank, use regular event"? Like I guess what I'm trying to ask is, can you ask DAX to look at a column to see if there's a replacement for a value, and if there is, to display it instead of what's already in another column?

Finished watching

What If, I just want to see the total of only specific 2 columns

This was EXACTLY what I was trying to accomplish - great video, thank you!

how fxCalcander created ?? anyone can help me ??

Great example, thanks. I do have a question though, how should i stop it from sending emails over and over. Also, can it be deployed for all users for example, a chatbot in Teams

this video is absolutely magical and exactly what i was looking for!!! Thank you!!!

Mackenziess consultant charge million of dollars for simple linear regression model, in name of ML and AI. 😂😂