Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
So I have a table listing courses, with a "created_at" and an "expires_at" columns that have date values. I want to calculate the number of active courses for a long period, consisting of those courses that have been created but haven't been expired. I have a date table, simply called Dates and the Date column in Dates and the "created_at" column in courses are related. How do I calculate the number of courses offered on any given date?
This is what I wrote but it doesn't work. Returns a strange looking step graph for some reason.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.