sum of all dates except last day on slicer

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[rajendraongole1]

Hi @Hussein_charif - you can adjust the logic to correctly get data from DateOnly - 1 and below, without including incorrect earlier dates (such as the one you mentioned, which was not what you expected)

 modified measure:

CostPerQuantity_ExcludeLastDate =
VAR LastDateSelected = MAX('valueEntry'[DateOnly])
VAR DateToFilter = LastDateSelected - 1
VAR SumCost =
SUMX(
FILTER(
'valueEntry',
'valueEntry'[DateOnly] <= DateToFilter
),
'valueEntry'[cost]
)
VAR SumQuantity =
SUMX(
FILTER(
'valueEntry',
'valueEntry'[DateOnly] <= DateToFilter
),
'valueEntry'[itemLedgerEntryQuantity]
)
RETURN
IF(
ISBLANK(DIVIDE(SumCost, SumQuantity)),
0,
DIVIDE(SumCost, SumQuantity, 0)
)

Hope this helps