Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
)))
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 !!! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.