Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |