Show Visual with cumulated Data by date

[FridolinWeiner]

I have a list with dates of expiring certificates.

I would like to show in a graph how many certificates (y axe) are valid on a certain day for the next 2 years.
All I manage so far is to show how many expire on each day, but not the total number of valid ones.

Could someone help me out with a fucntion for this?

I tried this, but I get an error:

CALCULATE(
COUNTA(Brandschutz_ErsteHilfe_ItemStatus[Valid until],
FILTER(
All(Brandschutz_ErsteHilfe_ItemStatus),Brandschutz_ErsteHilfe_ItemStatus[Valid until]
>=MIN(Brandschutz_ErsteHilfe_ItemStatus[Valid until])
)))

[Anand24]

Hi @FridolinWeiner ,
Please check this thread and DAX used:
https://community.powerbi.com/t5/Desktop/Cumulative-total-by-date/m-p/1907010 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn