I’m Amr A.Abdelhamid “AAA”; a CPA, & Finance expert with 20Y+ of experience. I created this channel to share knowledge about Financial Modeling, Data analysis, focusing on "MS excel", the tool widely used by accountants and finance experts. My goal is to spread the knowledge about new data & financial analysis techniques & to direct viewers towards the finance career future in the digital era. This requires learning not only the traditional excel, but also Power Query, Power Pivot, Power BI & more. The channel contains videos in English & Arabic
Asakwb Sir, when we try to add sales data in source file i'm not able to save the source file and i'm getting following error - " We cannot save RAWDATA.xlsx because file is read-only. To keep your changes, you'll need to save the workbook with a new name or in different location. Kindly help
"Avg Revenue Per Trax(X):=AVERAGEX(SalesT, [Total Revenue(X)])". When we put on this formula, how come DAX knew we wanted to find the average by the number of transactions, not the total of Quantity?
Amazing content and teaching style. I have one question only when you count toal quantity (Ssum) and Transection (Count). I am not sure what you were trying to show there. Can you please explain.