cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BharathM
Helper I
Helper I

Count of customer pod reaptead over last 12 months Dax Measure Need

PXL_20230124_121336707.MP.jpg

 

 

Hi Everyone 

 

I need the count of the customer pod reaptead from selected date to last 12 months how many times same customer pod repeated

 

In the first visual the data available in the table date and address and customer pods are in one table

 

In the second visual location wise we are using distinct count of customer pod to drill through from here to another visual

 

In the third visual we are having data from drill through so here we are taking customer pod dates and address rest of other columns

 

So here my requirement is to add same customer pod reaptead from selected date to last 12 months how many times customer pod repeated need measure for that so we can add it into the drill through page 

 

Thanks in advance 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@BharathM Not certain I follow, sample data as text and expected result would be much more helpful. But maybe:

 

Repeated = 
  VAR __Pod = MAX('Table'[Customer pod])
  VAR __Date = MAX('Table'[Date])
  VAR __MinDate = EDATE(__Date,-12)
  VAR __Table = FILTER(ALL('Table'),[Customer pod] = __Pod && [Date] >= __MinDate && [Date] <= __Date)
  VAR __Result = COUNTROWS(__Table)
RETURN
  __Result

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@BharathM Not certain I follow, sample data as text and expected result would be much more helpful. But maybe:

 

Repeated = 
  VAR __Pod = MAX('Table'[Customer pod])
  VAR __Date = MAX('Table'[Date])
  VAR __MinDate = EDATE(__Date,-12)
  VAR __Table = FILTER(ALL('Table'),[Customer pod] = __Pod && [Date] >= __MinDate && [Date] <= __Date)
  VAR __Result = COUNTROWS(__Table)
RETURN
  __Result

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler 

I need one more requirement i need to add 

One more field in the drill through page

 

Need to get the last delivery date of customer pod 

 

For example customer pod=12345_1

Date =1/13/2023

Previous delivery date =12/10/2022

 

I need to display the last delivery date

 

Please give me dax i will create new calculated column

 

Desired output 12344_1 date 12/10/2022

Prior date to be display

 

 

Hi @Greg_Deckler  Thank You So much its works for me

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors