Fantastic presentation. Well detailed. Already looking forward to mastering this and applying it at work. Thanks for sharing

This does not work on Excel 365 (from 2016) for Mac and there is no work around.

First one here! Thank you for sharing.. your videos are really helpful. Keep it up ✌🏾

very helpful

Thanks a lot. The regions in Power BI are showing undefined . Can you help with that ?

you have explained very well sir. Thank you. However, if u provide the data link it would be great to practice and verify the results from your video if we are doing it right. waiting for the link asap

When doing the diagram view - I am getting an error saying: "The relationship cannot be created because each column duplicates values" - I have followed the steps in your video and am unsure what I am doing wrong - this is great stuff btw!

Nice feature. Thanks for sharing

Amazing. Is it possible to work with a State Map e.g. Benue, and show seroprevalence of a disease based on some LGAs?

Very helpful, Thanks

Is this tool active on Google forms?

Hi Daniel. I have a problem once I click the source of table and click done, it doesn’t create the view for the MOP table in the app. I understand it has to be besides the Transactions table, any suggestions why this happens?

Nice one 🙌

Great Job. First time the detailed and informative analysis and excel formula with easy understandable and explanation. Thanks a lot for sharing such information. Waiting for more video.

How do I pay in installments for the amount received?

Nice work. It'll be great to take this further to build a format for actual and then a worksheet for Variance analysis with dashboards and visuals. Nice work boss.

why you put in Formula "Dr" *-1, not "Cr"*-1?

Nice. I tried to do the same thing with PIVOTBY. The problem is again one of Excel being too helpful and removing the empty columns.

Excel never ceases to amaze... I wanted to provide a suggestion on the color encoding on the conditionally formatted cells. Kindly, Bernard, I think it may be excessive to apply color where there's no values. I would go with coloring only where there is. Now, the following is personal preference and, a bit "Stephen Few-ish dogma" with regarding to table design. I would reserve the color encoding even lower, just coloring the figures according to aging ranges with a horizontal vertical tick. While watching the demo, you blew my mind that you could add a metric into the Rows quadrant (in the field pane). Amazing, but this only works on a 1-to-1 case. Meaning 1 unique invoice number per 1 corresponding total amount. Either way, amazing, thank you Bernard 🙏!!

great video

Firstly, thanks for the lessons. How did you get the Visualisation icons (Visual Types) to be placed in the Ribbon area? There is so much space wasted with where Visualisation is placed. I am not sure why it cant be a tab in the Ribbon area just like Modelling, View, Optimise.

So helpful Many thanks

It's 10pm in South Africa, and after struggling the whole day with this, I just found you, thank you so much❤❤

Thank you so much

Thanks Bernard, Kool and Simple

How do we calculate with part payments for some invoices ?

Excellent Tutorial brother, thank you! I going through the rest, easy to follow and completed app, Understood and Looks great!!!

justo lo que necesitaba, ¡muchas gracias!

Great work

hey, Great..... how can i get States maps, like country is INDIA and State is Telanana

Hello, when i use the same period last year dax, iam getting previous year values / please help?

I am from India. Really Informative Video.. Well Explained.

Very insightful!

thanks for your share,great video!!

THANK YOU TO SHOW THIS WOULD BE A WAY TO SOLV PROBLEM

It doesn't work. The embed option is not there.

Can I use my own the DATA? It will be a SINGLE EXCEL file with areas of GHANA. Simply a detail of SYNOPTIC PANEL. Please advise.

Thank you soo much!

I'm trying to get the link from Onedrive Personal. It rather has a encrypted URL. Do you suggest a work around?

tnx! just what I needed

Thank you so much😍

What if we dont know exactly the number of options innthe enumlist or if they are too many?

Clean solution. Thanks

Wonderful

really useful video so easy to follow

fórmula para category 30:32

this just scored me points with the boss - thanks

Thanks for a great video! 👍 Is that a decomposition tree that you used to show the votes cast? Do you have you got a video on how you did that? Thanks!!😄

Thank you so much

The example you gave for member 3 was about a person who paid the dues in a lump sum. If one person were to pay the dues in smaller quantities, how would it reflect in the first excel sheet