Forum Discussion
Plotting Count of Records between dates
Hi There, new to Power BI and struggling with this question. I'm trying to plot the number of active customers on each date using a line chart, like below:
I have one table I'm working with. I need to count the distinct number customer ID's when the following criteria are met:
date is >= Cycle Start Date
AND
date is < Cycle End Date
I feel like I'm missing something obvious here. Thank you for your help!
2 Replies
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.
