Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
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 , 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
Hi,
Share the download link of an MS Excel file and show the expected result in another tab of that file.
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.
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
I solved it, thx
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
95 | |
38 | |
30 |