I cannot approve your lack of an Oxford comma. Otherwise, excellent tutorial!

man you saved my life! I was trying everything and this video was the solution. Thanks.

Great overview. I have a similar need to use the Calculate(Average(Filter(Summarize ... combination; however, I notice that the total section disappears with this type of an approach. I have region beakdowns in my data so i create average weekly breakdowns per region; however, I would like to see the total average per week a national level as well. is there a way to achieve this??

Great stuff thanks for the clear and easy to follow breakdown of the options.

Shame MSFT didn't build this into PowerQuery. Why does something like that have to be so hard? In Python it's so simple!

For the Database within Vnet already, like a Postgresql flexible server with Private access (VNet Integration) setting. How can I perform the link to Synapse? I can not create private endpoint to my PostgreSQL.

Hello Again, i had the same issue, your method worked with me very well, but there was another issue, the filters didnt work with the map, for example i have 100$ sales in morocco, the 100$ did not change if i filter by departement or projects could you help ?

i have a question, how can lock the zoom level after finishing the work on the map ? i mean i want to show just a part of the map, the idea is when i finish setting the map, i want to zoom in a part of it and after that fixing this zoom to not be modified, to always focusing on one part of the map, could you help ?

Hey Mitch, is there an video about using power automate in place of logic app from Azure data factory?

Hey Mitchell. I have to say, this is the best and most relevant set of Data Factory videos I could find on KZbin. Great work! Thank you so much for putting in the effort, being succinct, and helping folks like me. Appreciate it!

Amazing!!!! Thank you!

Thank a lot Mitchell😊 I follow your tip and the result is great but when I need to change or filter year like 2023 or just 2024 it doesn't change follow, it's still show total calculate (2023 + 2024). And anyone know how to fix it? Thank you ✌️🏻

Hi - please create a video on how to connect blob storage to snowflake without having networks settings to open all networks

I spent 2 hours trying to do this another way. Using your video I figured it out almost instantaneously. Thanks!

Is would be good if you could do a video on the same subject matter but using Purview

Great!!! It's awesome!! Thanks 🎉

This is the best Virtual table demo I've used and got me over the hump. I've been fighting this problem by burdening my model with helper tables in power query. This approach with DAX will level me up to take advantage of measures and the correct row context. THANK YOU!

Very Clever!!!!! Omg i was racking my brain and could not figure it out. I'm coming from mapping in Tableau which has data labels.

Awesome vid thank you

Hi guys, there is no "average" in the menu. How to fix it?

Very useful method thank you so much👏👏

Excellent examples and explanations. But I have a problem working with Matrix visualisation and using 3-4 level grouping + calculating average values. At the row level everything is fine, but in the final totals and subtotals depending on the level of expanding madness happens. Examples with more complex situations that happen in a real environment would be great.

I’m really trying to learn this with using an Excel Source and an SQL table as my sink destination. I need that SQL table to use that excel file name. Do you have a video for that???

Amazing video, thank you!

The best explanation on ALLSELECTED so far. Keep up the excellent work. I really highly appreciate it. Thank you

2:30 to skip the bullshit

Doing it python works for me. R seems to have issues..

Woooooooow! Genius! Thank you so much, just what I needed.

Wanted to pass along a big thank you! I'm embarrassed on how long not having the correct integration services set in my linked services took me to realize. Thanks for calling that out in your video!

Thank you for the useful video. Can data labels be added using either Shape Map or Mapbox in Power BI?

I am trying to Select the columns based on pipeline parameterrization. Like passing the columns as A+B+C (assuming A,B, C are columns to be selected amount the columns, A,B,C,D,E,F)). Any idea how we can achieve it ?

super 👍 thanks Mit

amazing video , opens the fields of possibilities , thank you for sharing this very useful process

Very well presented! Thank You for the tip!

Thank you Mitchell for this, and communicating the steps to make it work. I have been working in Power Query via Excel, and was struggling to find the "Add Tables from Example" when returning webdata. My search brought me to this page looking for help with power query in Excel, and. I think for others, it's worth noting that this this feature is NOT in Power Query for Excel, only Power BI. Love your videos, love your training style, and I am a Pragmatics works fan, after one of your classes. Keep up the great work!

is there any method to show just the data lables ? i mean just the numerical values without showing the name of the state and showing the datalables at the exact location on the map could you help please ?

Much to like, but why does every Logic App presenter think they have to avoid the 80% use case -- uploading a blob to Azure Storage and triggering an ADF pipeline to put the data into Azure SQL? I seriously could not care less about all these specialty corner cases -- tweets, record-level SQL events, things that happen out on the Great Wild Web... it's all just distraction me. 🙂

Great explanation of concepts on this video.

This works like a charm. Thanks for the solution!

Thank you for the excellent content videos.

Very helpful video... learnt valuable information .. Thank you so much😎😎

Awesome tutorial as usual with the DAX Master. Crystal clear and concise, breaking down and making calculate() just easy like taking breakfast in the morning. Bravo, Michell Peterson!

I have a question Mitchell, how do you connect the Sales by State data with slicer (for example: Year slicer)

Amazing and fantastic explanation!

great tutorial. very useful... thanks.

How can we look at rolling averages over transactions instead of dates?

You are the GOAT!!!

Great video and thanks for taking the time to explain everything in detail. I know this video is a couple years old. Is there a way to not return a 3 month average for the first 2 rows where there is not enough previous data to give 3 month average?

1:43

Hi Mitchel which app are you using to record your video . I want to know how you hid your face when it's blocking the background