Forum Discussion
Plotting Count of Records between dates
To plot the number of active customers on each date in Power BI, you'll need to first create a calculated column that counts the distinct customer IDs based on the conditions you mentioned. To do this, you can use the DAX formula:
=COUNTD(FILTER(Table, [Date] >= [Cycle Start Date] && [Date] < [Cycle End Date]))
Once you have created this calculated column, you can then create a line chart visual by selecting the Date column as the X-axis and the calculated column as the Y-axis. This will display the number of active customers on each date, based on the conditions you specified.
Thank you for the help! This definitely helped me get there. I don't see any "COUNTD" function in Dax but maybe I don't totally understand how to use that. I ended up using CALCULATE(DistinctCount(FILTER) and that worked for me.