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.

v-xicai's avatar
v-xicai
Community Support
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.