- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hi
Hello
Here i have given the link for power bi file
https://drive.google.com/drive/folders/1Q7Hwsu11e4He64fjV_ShAZhWIkFzDRuW?usp=sharing
i want to find uniquire barcode those are purchased over 90 days ago.
expected answer would be 22 barcode count
plase help me to create a measure
thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

2 people tried but the expected result was not able to be made
if you go to the link you will get an Excel sample file as well as pbi file
I want the barcode count of those barcodes that are over -90 days as per year-month slicer
The expected result for
November 2023 page-1 sheet should give me a count of 20,
November 2023 page-2 sheet should give me a count of 46,
if you kindly see the shared link you will understand
requesting please help me
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@abc_777 , seem like file have been removed or link is correct
You can use measure like
calculate(distinctcount(Table[barcode]), filter(Table, Table[Date] <today() -90))
or, based on selected date
new meausre =
var _max= maxx(allselected(date), Date[Date]) //date tbale used
return
calculate(distinctcount(Table[barcode]), filter(all(Date), Date[Date] <today() -90)) //Joined date table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

thanks for your reply.
I have found an interesting thing when I am using your DAX formula.
I hope this time you be able to go to Google Drive and check the file
There I have put two Excel files one has 400 + sample something data and the other one has 500 + sample data. Column name and value all in are same format
In pbix file, I have created two separate pages (page 1 and page 2)
when on page 1 (500+ sample data) I used your formula I got the incorrect result
but
same time I used the same formula on page 2 for another Excel file (400+ sample data) I got the correct result
and in KPI when I change month from slicer KPI does not change 90 days back from that month
Would you mind having a look into that, please
https://drive.google.com/drive/folders/1r0UcGHmJ_0PtWw7G6s0rq-MQiVSypVei?usp=drive_link
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hello,
Can some one please help me out for this solution. thx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Share the download link of an MS Excel file and show the expected result in another tab of that file.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hello @Ashish_Mathur
https://drive.google.com/drive/folders/1r0UcGHmJ_0PtWw7G6s0rq-MQiVSypVei
this is a share link.
the expected answer is when I select slicer calendar it will only show me month-wise barcode distinct of that month those are over -90 days ago
items count that were last purchased more than 90 days ago
need help with this.
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I have not understood your question. Someone else will help you.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

2 people tried but the expected result was not able to be made
if you go to the link you will get an Excel sample file as well as pbi file
I want the barcode count of those barcodes that are over -90 days as per year-month slicer
The expected result for
November 2023 page-1 sheet should give me a count of 20,
November 2023 page-2 sheet should give me a count of 46,
if you kindly see the shared link you will understand
requesting please help me
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I solved it, thx

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

User | Count |
---|---|
87 | |
81 | |
53 | |
37 | |
35 |