Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i want t3 as output
Hi @amitchandak sir,
both are taking more time then early one i want to reduce according to utilization time. cannot we play with date table ?
@sajjadsaj , Try like
t3 =
VAR TotalSales = SUM(Orders[Sales])
VAR SalesByDay = CALCULATE(TotalSales, ALL('date'[day]))
VAR SalesByDateBins = CALCULATE(TotalSales, ALL('date'[Date (bins)]))
RETURN IF(SELECTEDVALUE('date'[day]), DIVIDE(TotalSales, SalesByDay), DIVIDE(TotalSales, SalesByDateBins))
or
t3 =
VAR TotalSales = SUM(Orders[Sales])
VAR SalesByDay = CALCULATE(TotalSales, ALL('date'[day]))
VAR SalesByDateBins = CALCULATE(TotalSales, ALL('date'[Date (bins)]))
RETURN IF(isinscope('date'[day]), DIVIDE(TotalSales, SalesByDay), DIVIDE(TotalSales, SalesByDateBins))
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |