Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

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...
Need Help
  • abc_777's avatar
    abc_777
    2 years ago

    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

amitchandak's avatar
amitchandak
Super User
2 years ago

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's avatar
abc_777
Solution Specialist
2 years ago

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's avatar
    abc_777
    Solution Specialist
    2 years ago

    hello,

     

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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

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