วีดีโอ

Couple years old but this helped me a ton in solving an issue this week. Thanks!

Thanks man. That's really helpful. However, you may want to consider slowing down a bit, because from my experience, people tend to get it faster when the explanation is slower and more subtle. For example you may want to say that the sorting is being taken care of by the visual and not by any table in the measure. You may want to show the results of intermediate steps, etc.

Your videos are really amazing I wish people can find you more! I had spent time searching for a solution and your channel was the only one that had such walkthrough.

I followed the same process on my semantic model but it has created 2 pqt files. Any suggestions how can I handle that?

excellent video!! Better than paid courses

Love to see the sincerity. I haven't muted Sandeep on social media....yet 😜

Amazing, 😮 more such videos please

Thanks much. Love to see when Sandeep Presents.

Thanks for sharing 🙇

Thanks again. Some good general tips sprinkled in there.

Great video!

Why don't you just allow the speaker to keep their video on and off for the rest of the participants?

The video was a great help. Is there any way to apply conditional formating to this?

This was a great help - thank you!

nice explanation.... it would be great if u provide the dataset so that we can practice simultaneously

amazing thank you so much for the clear explanation!!

Thanks Man, You saved my face in the company

Useful. Thank you.

I have a simple question, what does (baseReportURL) mean? Is it the link to the report itself? Or should I create a new report with the filters used? But how do I link them together?

Finished watching

Finished watching

Finished watching

@PowerBIHowTo - This was super helpful to back fill the blank spaces with the last dated data. I'm trying to use DAX to create a running total across multiple columns (e.g. for multiple personal financial accounts); but I cannot seem to create the running total because PBI Totals the 'Fact' data instead of the Filled In Data from using your DAX in this video. Any suggestions on how to push forward to create a total? From the video (time: 7:06)... if you wanted to Sum: North + South + East + West to create a Running Total using both Fact Data and Back Filled Data.... can you show how that's possible? Much appreciated for your video!!!

Nice one :) Scenario: If I have categories in my FP & plotting a line chart showing sales for each category (multi lines). Now if I select multiple category in FP slicer then line chart should only highlight those and rest other should be in grey colour. Anyway? Note: category column is dynamic its not static.

Hello, thanks a lot for the video. Can you explain please the measure "Title"?

excellent tutorial my dude!!

Hello, thank you for the videos. They have been helpful. I was wondering if you could show me how I can also capture Last Year Current Month So I can JUST show the LY Month. I've used a variety of formulas to try and capture this in the "Totals" Column but nothing is working as intended. Here is the closest I've gotten = VAR LastValidDate = [LastAvailableDate] VAR LYValue = CALCULATE( SELECTEDMEASURE(), SAMEPERIODLASTYEAR('DateTable'[Date]), 'DateTable'[Date] <= LastValidDate ) RETURN IF ( HASONEVALUE('DateTable'[MonthName]), LYValue, DIVIDE(LYValue, 1000000) // Show totals in millions if needed )

Excellent video.👍Thanks for sharing ❤. For the last step, instead of using List.MatchesAll, you can also use List.Sum(_) >0 to remove those rows that each has 0 value for the number columns.

How to apply to MoM variance?

Brilliant👍❤, thanks for sharing

Great job! Thanks for the help!

Great Gerhard. Great extension in VS Code. Thanks for the callout on my Vertipaq scripts.

Hello sir, hope you doing well, thanks for this tutorial, it makes my work a lot easier. But in this window function, has is a flaw. Whenever i put any filter let's say in a particular year or month, the function stops the running total and returns the same value as total sales. It does not work well in pivot table. Can you guide me by making a video

I watched yt videos, read a book, read a Microsoft site but i still don’t get what is the difference between many-to-many vs bridge + cross-filter solution. I was sure that many to many relation provide same result but in short way. It’s never explained. I read that there is not “blank” row and there are some problems with all() but I found no explanation. It is a huge chaos in that matter. Everyone also states that this is not true m2m relation (like a quote from power bi warning) and no one explains why.

Man, You are THE BEST!!!!

Hi Sir, Thank you for the solution. I was stuck at one point and your video helped me to implement similar usecase. Great content and amazing. Thanks again

Glad that I came across this site. Really helpful.

a totally excellent video, thank you

This is some amazing stuff!

Brilliant!

I am using your ideas of utilizing measures as part of the dataset and my reports run so much faster now! Thank you so much for your videos!

Thank you for great ideas and content! There is so little info on using power bi datasets with paginated reports, so your content is precious! Keep it coming! ❤

Thank you! ❤

Thanks111

Have you tested doing a crossjoin and then filtering based on the criteria? I wonder how fast it would be

Thanks, would it be possible to share GitHub link?

An excellent and informative session, as always. However, unless I missed it while grabbing a coffee, the most important question wasn't answered: What's the origin of "Four Moos," perhaps the most distinctive name in the Power BI community? We need this question answered. Performance testing doesn't get enough coverage, considering the widespread capacity performance issues out there - so an excellent topic choice. Having done quite a bit of work with the Realistic Load Test Tool, I find its concept great, but feel the implementation is just a bit too clunky to be practical. I've reverted to manual load testing: getting say 10 users to log in concurrently to a report and smash a random selection of slicers and filters continuously for 10 minutes. Then, using the FCMA (Fabric Capacity Metrics App), quantify the average interactive load per query hitting the capacity (% of capacity consumed). This approach feels more realistic & transparent to me. Thanks again for the session, great topic, knowledgable presenter, excellent questions, and plenty of food for thought.

Hello, if I want to compare more than two prices since I have 1000 products and they are registered per day, how can I do it?

I have used similar way of recreating the calculation group of time intelligence. the data is blank but the column header remains same