Forum Discussion

oren's avatar
oren
Icon for Helper III rankHelper III
5 years ago
Solved

create measure comparing dates from different tables

HI   i have a table with column "date from" and  column "date to" and anothe table with all dates isung it as a filter i want to creat a measure which will give me "true" or "false" if the date i...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    @oren
    You can create the following measure by checking the attached pbix if necessary.

    Medida: IF(SELECTEDVALUE('Table 2'[Date]) en VALUES('Table'[Date]),TRUE(),FALSE())
    date in valus true false.PNG
    Paul Zheng _ Community Support Team
    If this post helps, please accept it as the solution to help the other members find it faster.
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

oren , Try measure like

measure =
if(isblank(max(Date[Date])),0,1)

 

or


measure =
var _min =minx(allselected(date),date[date])
var _max =maxx(allselected(date),date[date])
return
if(isblank(calculate(countrow(Table), filter(Table, Table[Date] <=_max && Table[Date] >=_min))),0,1)