Ravindra BagaleCourses & study guides

29. Practice Exercises and Final Assignment

29.4 Module 8: Add Column, Calculated Columns and Measures

By Last updated:

  1. Use Column From Examples to create First Name from Customer Name.
  2. Create a Custom Column Order Line Total handling null Discount with ??.
  3. Write fnDeliveryBand and call it with Invoke Custom Function in both the Blinkit and Amazon Now queries.
  4. Add an Index column starting at 1001 with increment 1.
  5. Parse a JSON Drop Location column into lat, lng and area.
  6. Create 5-minute delivery buckets with Standard › Integer-Divide and Multiply.
  7. Add Order Date, Order Hour and Day Name using Date and Time menus.
  8. DAX calculated columns: Category (RELATED), Delivery Speed Band (SWITCH) with a sort column, Is Weekend in the Date table.
  9. Implement Net Sales both as a column + SUM and as a SUMX measure. Compare results and model size.
  10. Explain why "% Under 10 Mins" must be a measure.
  11. Create a _Measures table, display folders and ₹ formats. Add a dynamic format string for Total Sales.

Ravindra Bagale's Tip

Friends, many students check a measure only in the grand total. Test every measure in a table visual by City and by Month, and compare one or two cells with a manual calculation. Keep this in mind!