Count of customer reaptead over last 12 months Dax Measure Need

[BharathM]

Hi Everyone 

I need the count of the customer  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 are in one table

In the second visual location wise we are using distinct count of customer  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  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  repeated need measure for that so we can add it into the drill through page 

Thanks in advance 

[Greg_Deckler · Accepted solution]

@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.

[BharathM]

Hi @Greg_Deckler 

This measure is not working now when i was Enabling totals for the table visual it shows me below error

I changed measure also 

 --VAR __Pod = MAx('All Data (2)'[NavSalesFuels.CustomerPod])

    VAR __Pod = DISTINCT('All Data (2)'[NavSalesFuels.CustomerPod])

  VAR __Date = max('All Data (2)'[ShiftDate])

  VAR __MinDate = EDATE(__Date,-12)

  VAR __Table =

            FILTER(

                All('All Data (2)'),

                        'All Data (2)'[NavSalesFuels.CustomerPod] =

                          __Pod &&

                        'All Data (2)'[ShiftDate] >= __MinDate &&

                        'All Data (2)'[ShiftDate] <= __Date &&

                        'All Data (2)'[True Zero Count] = 1)

  VAR __Result =  COUNTROWS(SUMMARIZE(__Table,'All Data (2)'[ShiftDate]))

RETURN

  __Result

[BharathM]

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

[BharathM]

Hi @Greg_Deckler  Thank You So much its works for me