Forum Discussion

marlotmarques's avatar
marlotmarques
Frequent Visitor
5 years ago
Solved

Use the Slicer limit as Column value

Hello, I'm trying to calculate the Open Days for each ticket in my table, but the filter is important and I can't figure out how to set the Closed Date based on the limit of the filter (date sli...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    I would take a different approach.  Rather than keep 2 columns, i would use the Query Editor to have all dates in 1 column with one row for each date between the beginning and ending.  This way your slicer will accomodate all dates from both columns. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

marlotmarques , a measure like

 

max Close =
var _max = maxx(allselected([Date]), 'Date'[Date])
return
if(max(table[close date]) > _max , max, max(table[close date]))

marlotmarques's avatar
marlotmarques
Frequent Visitor
5 years ago

I've tried to adapt your suggestion to my BI, but I'm getting the following error:

The syntax for ',' is incorrect. (DAX(var _max = MAXX(ALLSELECTED('Calendar'[Date]), 'Calendar'[Date])returnIF( max(ConsultaPLR[Data encerramento]) > _max, max, max(ConsultaPLR[Data encerramento])))).

Any idea?