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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
abc_777
Solution Specialist
Solution Specialist

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

 

 

1 ACCEPTED SOLUTION

@Ashish_Mathur ,

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

View solution in original post

8 REPLIES 8
amitchandak
Super User
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

 

@amitchandak 

 

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 

abc_777
Solution Specialist
Solution Specialist

hello,

 

Can some one please help me out for this solution. thx

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/

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

I have not understood your question.  Someone else will help you.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur ,

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

abc_777
Solution Specialist
Solution Specialist

I solved it, thx

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors