Forum Discussion
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
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
8 Replies
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
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
hello,
Can some one please help me out for this solution. thx
