'Pass select Date Slicer to Filter in SummarizeColumns
I need to pass the dates selected in the filter to the function below:
SUMMARIZECOLUMNS ( VW_FCFO_2[PK_CFO], FILTER( ALLSELECTED(Calendario[Data]), Calendario[Data] >= [Data Inicial] && Calendario[Data] <= [Data Final] /*Calendario[Data] >= DATEVALUE("01/01/2022") && Calendario[Data] <= DATEVALUE("28/02/2022")*/ ), "Soma Total", [Valor Total] )
If I pass the fixed date, it works, but I need the date to be passed dynamically.
I created the following measurements:
Data Final = CALCULATE( MAX( Calendario[Data] ), ALLSELECTED( Calendario[Data] ) )
Data Inicial = CALCULATE( MIN( Calendario[Data] ), ALLSELECTED( Calendario[Data] ) )
At first it should work with these measures above, but it is not respecting the selected date and is passing the entire period of the calendar table, and not just the period of dates I selected in the filter.
Thank you,
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
