power bi community
2 Topicsundefined
PFA two datasets for your reference. PFB Scenario Objectives: 1) Load the Superstore data to calculate no. of orders that have been generated for the last 6 , 12 , 18 months based on a filter selection. 2) Load the BusinessE2E data to perform the below activities: Create an optimized data model Create dynamic YTD , MTD , QTD calculations based on user selection Calculate top and bottom n analysis for products based on sales and quantity based on user selection Allow users to dynamically change measures in the chart. Calculate sales, quantity and COGS for this.479Views0likes2Comments