Forum Discussion

munder1978's avatar
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's avatar
    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

amitchandak's avatar
amitchandak
Super User
4 years ago

munder1978 ,  If you have joined a date table or use a filter/slicer from the same table it will filter automatically

 

else you need to create a measure and add it in visual. Do for all measures OR filter measure for non blank at visual level

 

 

measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])

return

countrows(filter(Table, Table[Date]>=_min && Table[Date] <=_max))

 

munder1978's avatar
munder1978
Frequent Visitor
4 years ago

Thanks amitchandack is work in a part, but i need to know the date min and max, and with this i have the number off day in period, for example if the user filter the report between 1-1-2021 and 2-2-2021, i need the mesure show me this 2 date like min and max and with that i can use in the formula.

 

thanks and reagards