Hi, I am trying to create a filtered column that will filter all the dates into it.
The '#' represents responded and '20/01/2021' represents resolved. I want to have two columns to put on dashboard next to each other with their counts. Please see below.
Thank you very much, apprecite the help.
Go to Solution.
@Aziza , Create two new columns like and use that
if([resolved on date] ="#", blank(),[resolved on date] )
if([resolved on date] <>"#", blank(),[resolved on date] )
Proud to be a Super User!
View solution in original post
Measure_count# = CALCULATE(COUNT('table',[resolved opn date]),'table',[resolved opn date] = "#")
Resolved = Measure_count# - count('table',[resolved opn date])
Thank you very much!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.