Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Calculate MAX seems to put MAX value on total line

First time posting but just trying to figure out what im doing wrong here.

MEASURE:

Prior Total Costs =
CALCULATE([Total Costs],
FILTER(ALLSELECTED(Calendar1[Date]),
Calendar1[Date]<= MAX(Calendar1[Prior Plan Year Lookup Date])))

Screenshot:

Need it to return the total between the months not the max value.

2 REPLIES 2
Super User

What exactly are you trying to do?  Explain the question in simple English rather than just pasting a measure.  Show the expected result very clearly.  Share the download link of the PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Super User

@BenBernanke , Grand total is recalculated so it will give the last month in total

You can have a measure like

MEASURE:

Prior Total Costs =
Sumx(Calendar1[Month Year] ) ,  // Assumed month Year is on column
CALCULATE([Total Costs],
FILTER(ALLSELECTED(Calendar1[Date]),
Calendar1[Date]<= MAX(Calendar1[Prior Plan Year Lookup Date])))
)

Helpful resources

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors