Get sum of max date/period

[summer18]

Hi,

I would like to ask for your help on how to get the sum of max period displayed

In the screenshot below, the totals are all in sum by column but I want to display in TOTAL in first 3 columns the sum of max period:

I don't know how to post my pbix here on this message, can't see the icon to upload pbix.

[Greg_Deckler]

@summer18 - If I understand correctly, it sounds like Lookup Min/Max (without the lookup) https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

or  a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[harshnathani]

Hi @summer18 ,

Upoad your sample pbix using One Drive or Google Drive.

Regards,

Harsh Nathani

[summer18]

Hi @harshnathani ,

Here's the link of the pbix 

https://drive.google.com/file/d/1_Mzqk8euQaW2c5dXpNOSVaukGKp5e7V6/view?usp=sharing

[Ashish_Mathur · Accepted solution]

Hi,

I have solved for Adjustment.  Please solve for Cost and Expenses yourself.  You may dowload the PBI file from here.

Hope this helps.

[summer18]

Thanks @Ashish_Mathur it works

[Ashish_Mathur]

You are welcome.

[amitchandak]

@summer18 , Try same for all measures adjustments, sales, cost and expense

lastnonblankvalue(Table[Date],Sum(Table[adjustments]))

and take the max of date/period in the visual, use invoice no as row/axis/not summarized

[summer18]

Thanks @amitchandak for always helping me. Unfortunately, the user wants to display all the periods but in TOTAL row he wants to see the value of max date of the invoice. The invoice number is single select but the fiscal period is multiple selection.