Видео

I wish You explained it more deeply to understand why it works

Hi, I just wanted to say "Thanks" for taking the time to make this Hands-on Course & share the Data Model. It took me a while to figure, why your Seasonality Dax code was not working in my model: Your "Revenue Data" is already grouped by "Start of Week" Date and not on a daily basis. Might be helpful for others too.

Not exactly what I was looking for. However, it did help me a great deal. I am trying to replicate pipeline created by data engineer couple of years ago (they have left since then). In place of arm template deployment, they are using Copy Files to X location and then Publish Artifact. Not sure, how that works but your video helped me understood other things around that.

Bro I can't take images how can I take please tell me full process I had only uploaded my images online I having links only

how to amend the code when the difference is i.e. Diff = YTD - SPLY (same period last yr)? this code doesn't work in this case any idea?

That was a good post . But how to create a table with 4 wks 8wks and 16 wks data . Also table with current 4 wks vs previous 4wk comparision . Is it possible to create a date hierarchy for 4,8and 12 so that we can show it in single chart and enable hierarchy

Yeah how can we delete those watermarks without paying kvantillion dollars for credits per user & per month?)

Simply amazing! Very well done! 👏

Hello If you grant someone role access (apparently the read access) to some of the tables in a lakehouse from another workspace, will he be able to create a custom semantic model where for example he can define relationship that didn't exist between the tables in the original lakehouse?

Hello, if i am using one lakehouse as a single source of truth for several teams, which each one of them would require accessing a subset of the tables found in the lakehouse. The one lakehouse would be in a workspace A, and the user will reading the specified tables from workspaces B,C,D,.... where they will be also building their power bi reports. is it better to go with the role based data access, or to create a separate lakehouses in the Workspaces B,C,D,..... where i will be creating shortcuts with the subset of tables needed for their reporting needs? Thanks

I dearly liked this method and everyone was amazed. The only challenge I have is that my breakdowns are not sorting. Does anyone know what could be the problem. The sort column data type is whole number

HI Thank you this works briliantly as a measure do you know of a way to do this as a column and not in Power quarry

Unable to select the metric in action.

Thank you

This is really cool, but when i publish the report the images are not shown, do we need to purchase ?

Thanks for the video. I have tried using the data activator by setting an alert from a card visual. However, I am not able to create a new property from a field from the same semantic model to the same alert. Also, not sure how to integrate this trigger to power automate. Currently the users in the email list should have the same domain as the alert owner. I tried by adding an AD group with multiple domain users and didn't work. Is there any workaround you can think of, it would be appreciated.

Hey New Subscriber to you with your Amazing Lesson on Forecasting.. And could you please make a video on IMPORTANT DAX Calculations & SQL Quick tips for Preparing Data Analyst interview Thank you!

Hey and thans a lot for this amazing feature Great success to have a seasonal forecast at month level When displaying it on a graph for 2024 it is perfect (with mensual datas from january 2022 as inputs) Unfortunately, i want to project the forecast cumulative sum at end of 2024 but it doesnt work with classical function as SUMX because it made some mistakes with forecasted measures Do you have a solution for this ?

do you have the code?

Just started with a trial of Inforiver in Power BI and your Tutorials are a great starting point. Would like to see a Tutorial in writing formulas in Inforiver comparing Actual Data vs. Forecast Data, Total etc. I am struggling to address columns correct.

Id loved to learn how you incorporated unit costs into the PVM. Are you able to do a video on that? Much appreciated!

Thank you for sharing. I haven't played with it yet. I'd like to ask regarding 'weeklyData' variable. Why Addcolumns is wrapped in CALCULATETABLE with ALL('Date') modifier? What purpose does it serve?

Brillian job ! I'm still getting the Last Year Column on the right hand side and the Sort category reverted :( any workaround?

Andre as always a very good explanation with clear DAX code. On your new fancy website I can read the DAX code but I'm missing the PBIX.

love the new hat

Thanks for your time. Unfortunately, results from "Sales Forecast" Measure are off. Is the logic / Dax for "Sales Forecast - Seasonality" ok? EDIT: I think the logic of summing up all prior years could be misleading in growing business.

Thank you for taking the time to explain

you can find the original video here: ruclips.net/video/Suiw1hxtaUI/видео.html

this video generated a ton of questions, I tried to answer them all in this video: ruclips.net/video/fTv1VJRuHMg/видео.html

Well explained bro. Thanks so much Can you share the pbix file

Thanks man I've been searching for this for an hour

That's really cool! Thank you so much, you made my day 👍👍

I just love how youve been able to do time series forecasting with DAX. Just amazing!! Is it possible to share the pbix file or just the sales data on your blog just to follow along

Very nice, but I am not able to get this working. In the Measure "Sales Forecast - Trend" from your Blog, i get the message: Can not find name [Slope1]. Any idea? Where is this defined? Thanks in advance!

Good morning Sir I Built an Organization Chart with performance flow. I´m having an issue, the images are not showing up. How you did you upload those images on your chart, could you tell me please?

Also, the formula for mix variance is total Current Year Units * (PY unit price - PY average cost/unit) * mix change

When the mix for product A goes from 50% to 40%, the mix variance should be positive as you are selling less of 'bad' stuff

Could you provide the R coding as well I want to try and do both to see how well mine turned ?

Could you please share the calculations for each parameters like an equation? This would be of great help ...

Great lesson.On your blog, you added the WeeksCount to the Trend forecast calculation. What's the reason if I should ask

Can i use it without premium account??

Outstanding content. Keep going please.

omg I managed to delete several Azure resources with this stupid ARM template. THIS THING IS DANGEROUS!

when using the template currently, there is no elipsis to click to show the files. any ideas? thank you

excellent

Great video! Thanks

How to highlight single value in those bullet points?

Hola, sabes que intento crear un gráfico de cascada de la misma forma, pero al agregar un 4to ítem no me lo agrega de manera correcta, favor ayúdame a solucionar este problema, déjame tu email para compartirte mi problema

Would this new dataflow hava any codependecy with the original? What I mean is, if I update this new dataflow, would the original one also update? Is really important that this doesn't happen for me