Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Rince91
Helper I
Helper I

Count Unique values between a date range

Hey,

 

Had to share this as i've been trying to figure it out for a week now. Finaly got it.

 

So the intention of the below is to add a column in that defines if the row is between the start data and end date, adding a "Yes/No" where true or false. It then filters the table on "Yes" and counts the unique values in a specific coulmn. 

 

Where i have used this is to count the tickets raised last month and then compare to the tickets raised the previous month to show a specific increase or decrease in ticket numbers.

 

This took me ages to figure out, hopefully helps someone else!

 

 

Unique Count = 

VAR StartDate = EOMONTH(TODAY(),-2)+1
VAR EndDate = EOMONTH(TODAY(),-1)

RETURN
CALCULATE(
DISTINCTCOUNT(Table1[Refference]),
Filter(
ADDCOLUMNS(
Table1,
"Last Month", IF(Table1[CLOSE_TIME_Month_Year] >= StartDate
&& Table1[Table1] <= EndDate, "Yes", "No")),[Last Month] = "Yes"))

 

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.