DAX Function Help

[MaheshDadhich]

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 

[Greg_Deckler]

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.

[MaheshDadhich]

Thanks very much for your response !

Could you share the measure formula which you applied to get Max date.

Thanks 

[Greg_Deckler]

I used your formula MAX([ExtractDate]).

[MaheshDadhich]

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

[MaheshDadhich]

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