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.
Hello,
My requirement is to calculate max ExtractDate(Column Name) for each month in dataset after filtering the dataset based on user selected report parameter in Power BI Desktop.
For Example:
Dataset :
Plant Component material Month ExtractDate Forecast
P1 C1 M1 201601 5-Jan-16 10
P1 C1 M2 201601 8-Jan-16 15
P2 C1 M3 201601 10-Jan-16 20
If user select Plant = P1 and Component = C1 and Material = ALL then Max(ExtractDate) should be 8-Jan-16 But I am getting 10-Jan-16
How to calculate Max Date dynamically affter filtering the dataset by user selected parameter.
Thanks in Advance for help. Swift help is appreciated
Regards,
Mahesh
What visualization are you using for ExtractDate?
I created a measure with your formula, used a card for it and slicers for Plant and Component and when I select P1, the max date is the eighth as expected.
Thanks very much for your response !
I used your formula MAX([ExtractDate]).
MAX(ExtractDate) will calculate for entire data in Dataset But I need to calculate for every month.
For Example :
Plant Component material Month ExtractDate Forecast
P1 C1 M1 201601 5-Jan-16 10
P1 C1 M2 201601 8-Jan-16 15
P2 C1 M3 201601 10-Jan-16 20
P1 C1
Please avoid last post as It was bymistake sent while typing
MAX(ExtractDate) will calculate for entire data in Dataset But I need to calculate for every month.
For Example :
Plant Component material Month ExtractDate Forecast
P1 C1 M1 201601 5-Jan-16 10
P1 C1 M2 201601 8-Jan-16 15
P2 C1 M3 201601 10-Jan-16 20
P1 C1 M4 201602 20-Feb-16 10
P1 C1 M3 201602 22-Feb-16 20
If User select Plant = P1 and Component = C1 and Material = ALL then Result should be
Plant Component material Month ExtractDate Forecast MaxDate
P1 C1 M1 201601 5-Jan-16 10 8-Jan-16
P1 C1 M2 201601 8-Jan-16 15 8-Jan-16
P1 C1 M4 201602 20-Feb-16 10 22-Feb-16
P1 C1 M3 201602 22-Feb-16 20 22-Feb-16
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |