cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Solution Specialist

hi

Hello

Here i have given the link for power bi file

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

1 ACCEPTED SOLUTION
Solution Specialist

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

thanks

8 REPLIES 8
Super User

@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

Solution Specialist

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

thanks

Solution Specialist

hello,

Super User

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
Solution Specialist

hello @Ashish_Mathur

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

Super User

Regards,
Ashish Mathur
http://www.ashishmathur.com
Solution Specialist

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

thanks

Solution Specialist

I solved it, thx

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors