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.
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.
Solved! Go to 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 - 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.
Hi @harshnathani ,
Here's the link of the pbix
https://drive.google.com/file/d/1_Mzqk8euQaW2c5dXpNOSVaukGKp5e7V6/view?usp=sharing
Hi,
I have solved for Adjustment. Please solve for Cost and Expenses yourself. You may dowload the PBI file from here.
Hope this helps.
You are welcome.
@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
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |