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

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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