cancel
Showing results for 
Search instead for 
Did you mean: 

Supreme Eats Data set calculations using power BI

180 Views
Highlighted
KeerthyJayaveu New Member
New Member

Supreme Eats Data set calculations using power BI

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
 
 
Picture1.png
 
 
 
 
 
 
 
 
  
 
---------------------------------------------------------------------------------
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"))
 
Picture1.png