Forum Discussion

mosman's avatar
mosman
Frequent Visitor
6 years ago
Solved

Capture Time Slicer Minimum Value

Hello all,   I have a table with account number, balance, transaction date, and correspondance date. In my report I have a time slicer for the transaction date, so users can see balances for the ac...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi mosman ,

     

    You can create measure to get the date range like DAX below:

    Date range=
Var MinDate = CALCULATE(MIN(Table1[transaction date]),ALLSELECTED(Table1[transaction date]))
Var MaxDate = CALCULATE(MAX(Table1[transaction date]),ALLSELECTED(Table1[transaction date]))
Return
DATEDIFF(MinDate, MAXDate, DAY)

    Best Regards,

    Amy

     

    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
6 years ago

Refer to this. You have to create an inactive join and activate it as per need. (Not exact but similar)

https://community.powerbi.com/t5/Desktop/DATE-RANGE-SLICERS-TO-COMPARE-NETSALES-OF-A-DATE-RANGE/td-p/42251

 

So you will relation with both dates with the same Date/time table.

One join will be an inactive correspondence date.

Activate correspondence date in a formula using use relation.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Min max can be taken 

     

    Change Date End = 
Var _endDate= Maxx(ALLSELECTED('Date'[Date Filer]),ENDOFMONTH('Date'[Date Filer]))
Var   _start_date= minx(ALLSELECTED('Date'[Date Filer]),'Date'[Date Filer]))


return
_endDate & " " & _start_date