In this video, I demonstrated how to write the DAX formula and using the GUI in Power Query to calculate Sales Amount by Product Category.