Forum Discussion
Solved
Match multiple values is seperate table using ID and Date
I am making a demo IoT device monitoring dashboard. I can't understand which function should i use to check if devices are online on a certain date. This is my sample report table1 from which I s...
Hello @James_CA ,
First, you must create a date table:
Dim_Date = CALENDARAUTO()You can then use the following measure as a value in the viusal array:
Measure = VAR A = CALCULATE(MAX('Table'[device ID]),FILTER('Table','Table'[Date] = MAX(Dim_Date[Date]))) RETURN IF(ISBLANK(A),"False","True")If this post helps, then consider Accept it as the solution to help other members find it faster.
Best regards
Dedmon Dai
Hello @James_CA ,
First, you must create a date table:
Dim_Date = CALENDARAUTO()
You can then use the following measure as a value in the viusal array:
Measure = VAR A = CALCULATE(MAX('Table'[device ID]),FILTER('Table','Table'[Date] = MAX(Dim_Date[Date]))) RETURN IF(ISBLANK(A),"False","True")
If this post helps, then consider Accept it as the solution to help other members find it faster.
Best regards
Dedmon Dai
Thank you so much