hi

[abc_777]

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

[amitchandak]

@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

[abc_777]

@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]

hello,

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

[Ashish_Mathur]

Hi,

Share the download link of an MS Excel file and show the expected result in another tab of that file.

[abc_777]

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

[Ashish_Mathur]

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

[abc_777 · 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

[abc_777]

I solved it, thx