Forum Discussion
android1
Post Patron
Post PatronFilter between hours in the day
Hi, This calc column 8AM-10PM = IF(HOUR(vw_PivotChargesFrontPage[Visits_StartTime]) >= 8 && HOUR(vw_PivotChargesFrontPage[Visits_EndTime]) <= 22 ,TRUE(),FALSE()) returns all calls with a sta...
Would need sample data posted that I can copy and paste, just been hacking up to this point.
Add the following Boolean expression as well.
vw_PivotChargesFrontPage[Visits_StartTime] <= vw_PivotChargesFrontPage[Visits_EndTime]
android1Post Patron
Post PatronYes, thank you. Greg_Deckler Your code works perfectly with the added expression from v-chuncz-msft
Greg_Deckler
Community Champion
Community ChampionCool! The power of teamwork!