Forum Discussion

xti224's avatar
xti224
Regular Visitor
4 years ago
Solved

sort custom column

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, xti224 

    Try to create a measure like this:

    isShow = 
var _selectedDate=SELECTEDVALUE(Date1[Date])
var _45=IF(SELECTEDVALUE(Table1[Date])<=_selectedDate&&SELECTEDVALUE(Table1[Date])>=_selectedDate-45,1,0)
return _45

    And filter items with the measure equal to 1 in the filter pane

    Result:

    Please refer to the attachment below for details.

    Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

xti224's avatar
xti224
Regular Visitor
4 years ago

I need whatever the user selects for date1 (ex. 11/30/2021) to return the same date that is used on the visual  date2 and anything else in the last 45 days (return values ex. 10/15/2021 to 11/30/2021) but these are two separate table fields. and Yes date1 would be a dropdown list for the user to select a date

Anonymous's avatar
Anonymous
Not applicable
4 years ago

So I think what I wrote above would fit you needs, except that Date2 should be Date1