Reply
abc_777
Super User
Super User
Partially syndicated - Outbound

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

Syndicated - Outbound

@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

Syndicated - Outbound

@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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

@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 

Syndicated - Outbound

hello,

 

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

Syndicated - Outbound

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/

Syndicated - Outbound

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

Syndicated - Outbound

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Syndicated - Outbound

@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

Syndicated - Outbound

I solved it, thx

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)