Forum Discussion
Solved
power bi countrows between range
Hi guys, Im looking for a solution to count how many snapshots do we have which are between 0-5, 5-15 and over 15 days old. I could do it easily in xls like : =COUNTIFS(Actual!I:I,"EMEA",Actu...
Aadwark , you can simply create a new column
If [Snapshot Age] is a column and then you can use count of any column
Switch(true(),
[Snapshot Age] < 5, " Days < 5" ,
[Snapshot Age] < 15, " Days 5 - 15" ,
" >15" )
If [Snapshot Age] is measure follow the link I have given in last update
Aadwark , you can simply create a new column
If [Snapshot Age] is a column and then you can use count of any column
Switch(true(),
[Snapshot Age] < 5, " Days < 5" ,
[Snapshot Age] < 15, " Days 5 - 15" ,
" >15" )
If [Snapshot Age] is measure follow the link I have given in last update
Awesome, it was working
Thank you so much