Forum Discussion
Solved
Count rows before current day in visual
Hi, I have a table with information about incidents. For example created and solved date. That table is connected to a date table via the created date. I have now a visual where i easly can coun...
baekelal
Now is clear. You have alot of zeros. All records with zero "Oplgelost" Date will line below any selected date. This shall solve the problemTotaal aantal opgeloste incidenten = VAR CurrentDate = MAX ( Kalender[Datum] ) RETURN CALCULATE ( COUNTROWS ( 'Incidenten' ), USERELATIONSHIP ( Incidenten[Opgelost], Kalender[Datum] ), Kalender[Datum] <= CurrentDate, NOT ISBLANK ( Incidenten[Opgelost] ), Incidenten[Opgelost] <> 0 )I kept the NOT ISBLANK condition incase you have blank dates. Please check and let me know
Hi,
Hope 50 lines tell's enough
Nummer Geopend Opgelost INC0010002 24/01/2022 0:00 24/01/2022 0:00 INC0010003 24/01/2022 0:00 24/01/2022 0:00 INC0010006 24/01/2022 0:00 24/01/2022 0:00 INC0010008 24/01/2022 0:00 INC0010019 25/01/2022 0:00 26/01/2022 0:00 INC0010012 25/01/2022 0:00 25/01/2022 0:00 INC0010021 26/01/2022 0:00 26/01/2022 0:00 INC0010024 26/01/2022 0:00 26/01/2022 0:00 INC0010026 26/01/2022 0:00 INC0010033 27/01/2022 0:00 INC0010041 28/01/2022 0:00 3/02/2022 0:00 INC0010039 28/01/2022 0:00 28/01/2022 0:00 INC0010096 31/01/2022 0:00 18/02/2022 0:00 INC0010095 31/01/2022 0:00 15/02/2022 0:00 INC0010100 31/01/2022 0:00 15/02/2022 0:00 INC0010056 31/01/2022 0:00 14/02/2022 0:00 INC0010084 31/01/2022 0:00 14/02/2022 0:00 INC0010099 31/01/2022 0:00 11/02/2022 0:00 INC0010067 31/01/2022 0:00 9/02/2022 0:00 INC0010073 31/01/2022 0:00 9/02/2022 0:00 INC0010057 31/01/2022 0:00 8/02/2022 0:00 INC0010072 31/01/2022 0:00 8/02/2022 0:00 INC0010079 31/01/2022 0:00 8/02/2022 0:00 INC0010088 31/01/2022 0:00 8/02/2022 0:00 INC0010058 31/01/2022 0:00 7/02/2022 0:00 INC0010064 31/01/2022 0:00 7/02/2022 0:00 INC0010055 31/01/2022 0:00 4/02/2022 0:00 INC0010065 31/01/2022 0:00 4/02/2022 0:00 INC0010069 31/01/2022 0:00 4/02/2022 0:00 INC0010077 31/01/2022 0:00 4/02/2022 0:00 INC0010089 31/01/2022 0:00 4/02/2022 0:00 INC0010092 31/01/2022 0:00 4/02/2022 0:00 INC0010060 31/01/2022 0:00 2/02/2022 0:00 INC0010066 31/01/2022 0:00 2/02/2022 0:00 INC0010083 31/01/2022 0:00 2/02/2022 0:00 INC0010104 31/01/2022 0:00 2/02/2022 0:00 INC0010050 31/01/2022 0:00 1/02/2022 0:00 INC0010103 31/01/2022 0:00 31/01/2022 0:00 INC0010048 31/01/2022 0:00 INC0010049 31/01/2022 0:00 INC0010051 31/01/2022 0:00 INC0010052 31/01/2022 0:00 INC0010053 31/01/2022 0:00 INC0010054 31/01/2022 0:00 INC0010059 31/01/2022 0:00 INC0010061 31/01/2022 0:00 INC0010063 31/01/2022 0:00 INC0010068 31/01/2022 0:00 INC0010070 31/01/2022 0:00 - tamerj1
Community Champion
baekelal
Now is clear. You have alot of zeros. All records with zero "Oplgelost" Date will line below any selected date. This shall solve the problemTotaal aantal opgeloste incidenten = VAR CurrentDate = MAX ( Kalender[Datum] ) RETURN CALCULATE ( COUNTROWS ( 'Incidenten' ), USERELATIONSHIP ( Incidenten[Opgelost], Kalender[Datum] ), Kalender[Datum] <= CurrentDate, NOT ISBLANK ( Incidenten[Opgelost] ), Incidenten[Opgelost] <> 0 )I kept the NOT ISBLANK condition incase you have blank dates. Please check and let me know
This works !!!
Thanks alot.