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 correcta" but i need use the start and end date selection that the user define to pull the data from "fecha T"

 

thanks and regards

 

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

5 Replies

  • 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

  • Anonymous's avatar
    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:

    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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      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

      munder1978_0-1638199837263.png

      Thanks a lot

  • Anonymous's avatar
    Anonymous
    Not applicable
    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