The sum depends on the measures taken from the date filter

[PiotrP]

Hello, I would like to ask for help with the measure which should be dynamic from the DWDateKey date filter:

the filter uses two measures that take min and max date minus one year:

Data max = DATE(YEAR(max(ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey]))-1,MONTH(max(ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey])), DAY(max(ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey])))

and

Data min = DATE(YEAR(min(ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey]))-1,MONTH(min(ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey])), DAY(min(ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey])))

 and the main measure that is to sum the value taking into account the two above-mentioned measure

Miara 2 = CALCULATE (

SUM ( ERP_Invoice_product_region_WZ_budzet_Data[prowartnetto] ),

FILTER (

ALL( ERP_Invoice_product_region_WZ_budzet_Data ),

ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey] >= [Data min]

&& ERP_Invoice_product_region_WZ_budzet_Data[DWDateKey] <= [Data max]

))

[selimovd]

Hey @PiotrP ,

what exactly is your question?

Best regards

Denis

[PiotrP]

I would like to display the sum from the table ERP_Invoice_product_region_WZ_budzet_Data [prowartnetto] where I have a date filter that displays the min and max date from the filter. I reduce the minimum and maximum dates by one year. and in this option the measure will be the sum of the table ERP_Invoice_product_region_WZ_budzet_Data [prowartnetto] in the range of dates resulting from the measures of min and max dates. I apologize for my English

[PiotrP]

measure: Measure 2 = CALCULATE ( SUM (ERP_Invoice_product_region_WZ_budzet_Data [prowartnetto]), FILTER ( ALL (ERP_Invoice_product_region_WZ_budzet_Data), ERP_Invoice_product_region_WZ_budzet_Data [DWDateKey]> = [Date min] && ERP_Invoice_product_region_WZ_budzet_Data [DWDateKey] <= [Data max] )) it does not return any value to me. And it should be because between dates I have items that should add up. I do not know if the measure and the idea of display data is correct