Thanks for the great efforts, it’s really helpful, yet, I would like to ask what about having more than one company and need to apply filters, I’ve done that but every time I apply the filters, total assets, liabilities, and total equity + liability are always gone as if the filter is being applied to the totals display as well. Thanks for your answer in advance if you can help out
@azizquazi27 күн бұрын
Hi, was there any follow-up video of the sensitivity analysis? Looks like, I cannot find this video. Thanks.
@James-wl6btАй бұрын
This works but makes my Power Bi really lag. Any ideas on how I can solve?
@bendavidson1269Ай бұрын
Hey, great vid! any advice as to how to handle the addition of new accounts? I feel like it would be very difficult considering the layout and order stuff
@Haleysilver-q5wАй бұрын
agreed! I sort of found a work around so far but its only been a day since i replicated this so i maybe havent encountered all potential issues haha. I used formulas in my table like this for my sorting for my Primary Key column =IF(ROW()=2, 101, IF([@Account] = OFFSET([@Account], -1, 0), OFFSET([@[Primary Key]], -1, 0), OFFSET([@[Primary Key]], -1, 0) + 1)) I made a primary key column that literally goes from 1 and down until the end, i have my excel tab sorted by the FS order column which i made using this formula so that the income statement is the top always =IF([@[Financial Statement Type]]="Income Statement", 101, IF([@[Financial Statement Type]]="Balance Sheet", 201, IF([@[Financial Statement Type]]="Cash Flow Statement", 301, IF([@[Financial Statement Type]]="Cash Movement", 401, 0)))) then for my levels i did =IF(ROW()=2, 101, IF([@[Level 0]] = OFFSET([@[Level 0]], -1, 0), OFFSET([@[Level 0 Order]], -1, 0), OFFSET([@[Level 0 Order]], -1, 0) + 1)) and so on. These formulas are essentially saying if this rows level 0 is the same/equal to the level 0 cell above it then keep the sort # the same if not add 1. KEY thing though is DO NOT RESORT your data it will mess up your orders to help with that i added a copy and pasted version of the primary key column so if it ever got resorted by accident you have a starting point to resort it and then fix any that got out of order thankfully accounts arent added all that often. SO that being said when you add a new account you can just add a row in where you want it to be sorted so if its cash put it in the middle of your cash accounts or the bottom and those formulas will do their thing to edit the orders below once you add the rest for each level column. Sorry if thats too confusing and probably still not the best solution to make it smoother.
@user-vo3mt9wd2mАй бұрын
This is very useful. Thank you. Instead of using current month, current quarter, current year, how would you go about choosing a specific period with a starting month and ending month or starting date and ending date?
@ramnathrajagopalan0510Ай бұрын
Perfect thank you
@peterrender4716Ай бұрын
Thanks Chris, this is excellent and solves several challenges for me carrying out this type of analysis. The one thing that I am struggling with is the sorting of the columns using the level orders. In particular, Level 1 does not work with my database which appears to be because the Level 1 column includes several blanks (same content) which have several different numbers in the Level 1 order column. I cannot find a way to resolve this issue. Can you help me to resolve this? Thanks
@Haleysilver-q5wАй бұрын
I am having the same issue
@Haleysilver-q5wАй бұрын
I got something to work. I filtered down to literally just one row of data then since it still said i couldnt sort my level 1s to each other i did more googling and i added this SortLevel1 = 'youtablename here'[Level 1 Order] as an added column into the mapping table. Still only one row of data. I then told it to sort my level 1 by this SortLevel1 and it worked i then went and unfiltered everything in powerquery. I did this for each level 1,2,3,4 for my work file. For some reason level 2 it wouldnt let me still so i will try again maybe later but the rest worked. Hope this helps you!!!
@infinger20062 ай бұрын
Probably pedantic for many, but I loved the day of week sorting / key use.
@tracey-leefebruary45672 ай бұрын
Hi there, Could you please explain the sorting for your level 3 order. I don't understand why level 1 and level 2 is sorted in sequence but level 3 skips a few numbers. I have been staring at the sheet for a while now and can't figure it out. Great video BTW!
@DeepakVasudevan-kg5ld2 ай бұрын
thanks thalaiva😎
@JayWay-tb8sw2 ай бұрын
Can anyone elaborate on how to get PY Amount to calculate correctly?
@vipul4raf2 ай бұрын
How did you created Stop_word table you have not mentioned. I think you have skiped some timline.
@user-kf3nq6yx6e2 ай бұрын
This is an excellent introduction thank you so much! Invaluable!!
@alexkoren73952 ай бұрын
Are you using the + and - in your grid in any kind of way? I am trying to get the values be negative and positive on certain levels of the hierarchy
@skymen46722 ай бұрын
Great Video! Would love to see how you mark the special variantions and especially how you model other rules for special variances like "9 items in a row ascending/descending".
@federicourrea19102 ай бұрын
Amazing Video!!! I am trying to combine the learnings from the video to a table I have in my company, quick question, how would you go about getting the initial share capital (assuming it has not changed in years) so when you take a desired year to filter it gets included?
@Sisi-vp7xs3 ай бұрын
Thank you for the video. It’s really helpful and simple to understand ❤
@fer54663 ай бұрын
Hello, i did this model for Qatar 2022 at my office and everyone were really excited for it, now as American Cup is coming I was requested to do another one but with American Cup design. So thank you very much for this video, it helped me a lot wit Power BI.
@va67713 ай бұрын
How did you color the result tab?
@funmilayoadabanija24133 ай бұрын
Thanks for the insightful tutorial, i learnt alot from it. I can't seem to find the next tutorial which is going to focus more on sensitivity analysis, monte carlo analysis, and Power BI visualization. If this has been posted, i would appreciate it if you respond with the link.
@shumalumuki3 ай бұрын
Thank you for the great video explanation. This version is easier to learn. Following your steps I made one successful sample in Power BI. Just one question, why here we do not consider subgrouping the raw data? Xbar-R
@zm94753 ай бұрын
So eloquently and patiently explained and thank you for sharing the files
@manuelbelenguer33363 ай бұрын
Thank you very much! You're a master!
@nurqamarinamohdnoor24923 ай бұрын
How the score sentiments is set?
@sureshsonti80973 ай бұрын
Can someone please share the dataset file
@karthiktiruvanallur73773 ай бұрын
Thank you this was very helpful 👌
@miransh4 ай бұрын
FYI -Volume is very low for Canada- cannot hear - would you please fix - thanks
@Broadb1ll4 ай бұрын
Hi - Great video - thanks! Am I right in saying the the Azure map visual will replace the shape map visual. If so, is there a way in Azure to create a polygon map based on MSOA's. Using a JSON file?
@Riftzed4 ай бұрын
Is this another Power BI version ? Because i havent these options specially when you create the lines
@brianbaheramouzegarletsbui65334 ай бұрын
Great work. You made it look so easy to repeat the steps. Thank you.
@katiereyes5974 ай бұрын
This was so helpful. Thank you.
@trevski654 ай бұрын
Hi Mark, I have applied to attend the NHS course, has the path to the file you demo above changed? Thank you.
@chriscox38774 ай бұрын
Great video, but I think there is something missing as the table is incorrect. Wolves and Sheffield Utd should be reversed as Wolves have a better GD than Sheffield Utd. The same goes for West Ham, Watford and Bournemouth. So how do you organise a rank based on Pts being the same to then filter by GD and if GD is the same then by GF?
@Jannerparejagutierrez4 ай бұрын
This is very good video my friend, thank you very much!
@oscarestorach61624 ай бұрын
You are great, thanks a lot to share your knowledge
@Hansonartuk504 ай бұрын
There's some really useful information here. Many thanks for taking the time to put it together, excellent tutorial.
@sadyaz644 ай бұрын
thank you
@lambanlaa4 ай бұрын
Your presentation of this topic is the most clear I have watched. Thank you.
@rahulmaurya26075 ай бұрын
Hi, I went through the video multiple times but couldn't find how the income statement rollup Excel sheet was getting used in DAX. Have a similar requirement where on the report we need to show positive amounts but rollup should be based on the sign of the parent. Any references are welcome or if someone could point me to the part in the video I might have missed. Thanks
@dpv3435 ай бұрын
I cannot find that in the video either and also want to show value without the negative sign but still want it subtracted.
@rahulmaurya26075 ай бұрын
@@dpv343 Maybe I missed something but will look at the video againPBIX file along with other video for chasflow he has shared I just liked the entirety of the solution here why I wanted to take this approach. @LondonBusinessAnalyticsGroup any reference would be helpful if you read this comment.
@zyzt3m19 күн бұрын
was wondering the same and came up with rewriting the measures (need to repeat for other scenarios as well). Actuals = var calc = CALCULATE([GL Amount Treatas],IncomeStatementLayout[Main Income Statement Line]=TRUE) + [Blank Line] var _sign = IF(Selectedvalue(Mapping[Value]) = "+", 1, -1) Return calc * _sign
@rahulmaurya260719 күн бұрын
@@zyzt3m I tried various methods but nothing worked. When I use lot of measures the dashboard will crash saying resource exceeded. Went with the option to precalculated everything in DB and then bring the data in powerbi. We had another requirement for user level security so the data had to be very granular to do rollups based on access.
@namubiruevelyn23935 ай бұрын
U jst won a subscriber
@namubiruevelyn23935 ай бұрын
Excellent you saved me 😊It worked perfectly well... Watching from Uganda
@petercompton5385 ай бұрын
Hi Chris, another great video, thanks very much. Just one question - in the date table, you have trues and falses in the current month, current quarter and current year columns - am I right to assume this is formula driven?
@petercompton5385 ай бұрын
Thanks Chris, that is outstanding. So much easier to understand than anything I have seen elsewhere. I look forward to implementing it
@BigBrownTruck225 ай бұрын
My categories for some reason always includes a (Blank) option, even though there are no blanks in my dataset and I included no additional rows (or blanks) in the slicer table. How can I get rid of this (Blank) option? Thanks!
@akankshapriya65315 ай бұрын
great content was searching from long
@parajf5 ай бұрын
Great explanation
@apamwamba5 ай бұрын
List of countries is limited. So one has to use json. Great video
@user-np8km1ib4b5 ай бұрын
I can't find the follow-up video promised at the end. Is it uploaded on the channel?