Forum Discussion

munder1978

Frequent Visitor

4 years ago

Solved

date from filter

HI guys i have a formula in dax that i need add the last and the start date from the filter (date) in the report that the user defined, is possible this? the filter in the report use "fecha c...

Show and Tell

Anonymous
4 years ago
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
date from filter.pbix79 KB

Anonymous

Not applicable

4 years ago

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: