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
kb177
Helper II
Helper II

check if value exist in previous file and not in present file

Hi,

 I want to check if any value was present in previous month file and not in present file

can there be a measure or dax to compare present month file and previous month file

as in the below example ID 456 was present in april and may and in June it should show Not found

 

Expected result

month   ID

April'23 456

May'23 456

June '23 Not found

1 REPLY 1
Anonymous
Not applicable

Hi @kb177 ,

Please have a try.

 Create a calculated column.

MonthYear = FORMAT([Date], "MMM'YY")

 

`Then create 2 measures.

CurrentMonthCount = DISTINCTCOUNT('Table'[ID])
PreviousMonthCount = CALCULATE(DISTINCTCOUNT('Table'[ID]), DATEADD('Table'[Date], -1, MONTH))

Finally, create a measure that checks if any IDs were present in the previous month but not in the current month.

NotFound = IF(PreviousMonthCount - CurrentMonthCount > 0, "Not found", BLANK())

 

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

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.