Forum Discussion
date from filter
Hi munder1978 ,
Here are the steps you can follow：
1. Create measure.
all_amount = SUMX(ALL('Table'),'Table'[Precio])min_Date = MIN('Table'[Fecha Correcta])min_Date = MIN('Table'[Fecha Correcta])2. Use Smart narrative visual objects.
3. In the dialog box that appears, write down the text first, and click +Value to find the corresponding measure
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi munder1978 ,
I created some data:
Here are the steps you can follow：
You can use [Fecha Correcta] as a slicer, select two values as the maximum and minimum.
Using the min() and max() functions to obtain the maximum and minimum values of the slicer.
1. Create measure.
Measure =
var _min=MIN('Table'[Fecha Correcta])
var _max=MAX('Table'[Fecha Correcta])
return
CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[Fecha T]>=_min&&'Table'[Fecha T]<=_max))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hola Liu Yang
something like that is what I need but it does not give me the right value, create a more detailed vision to see if you can help me
Thanks a lot
