topic Re: DAX Function Help in Developer

DAX Function Help

MaheshDadhich — Wed, 06 Jul 2016 11:10:08 GMT

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

Re: DAX Function Help

Greg_Deckler — Wed, 06 Jul 2016 13:26:16 GMT

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.

Re: DAX Function Help

MaheshDadhich — Wed, 06 Jul 2016 16:08:17 GMT

Thanks very much for your response !

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

Thanks

Re: DAX Function Help

Greg_Deckler — Wed, 06 Jul 2016 17:57:47 GMT

I used your formula MAX([ExtractDate]).

Re: DAX Function Help

MaheshDadhich — Thu, 07 Jul 2016 04:49:14 GMT

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

Re: DAX Function Help

MaheshDadhich — Thu, 07 Jul 2016 04:54:49 GMT

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