Supreme Eats Data set calculations using power BI

KeerthyJayaveu · ‎01-10-2020

Hi All,

I have made some calculations for the SupremEats Data uing power BI.

Revenue = Order_Details[Quantity]*Order_Details[UnitPrice]

Total sales LY = CALCULATE( SUM(Order_Details[Revenue]), SAMEPERIODLASTYEAR(Orders[OrderDate].[Date]))

Diff.Between TY and LY = SUM(Order_Details[Revenue])-[Total sales LY]

Diff.Between TY and LY (Removing prev yr data) = IF(ISBLANK([Total sales LY]),BLANK(), SUM(Order_Details[Revenue])-[Total sales LY])

% calculations between TY and LY = CALCULATE([Diff.Between TY and LY]/SUM(Order_Details[Revenue]))*100

---------------------------------------------------------------------------------

Date Diff Col = DATEDIFF((Orders[ShippedDate].[Date]), (Orders[RequiredDate].[Date]), DAY )

Date Diff = DATEDIFF(MIN(Orders[ShippedDate]), MAX(Orders[RequiredDate]), DAY)

Bucket for Date Diff = IF([Date Diff]< 0 , " Critical", IF(AND([Date Diff]>0,[Date Diff]<10), "Average", "Good"))