Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
3 | |
2 | |
2 |