Forum Discussion
Solved
MAX DAX Function giving incorrect sum
Hi, I have a requirement where I have to multiply an amount by 5 if the current month is the first month of quarter, else multiply by 4. Ex: if the month is January(1), April(4), July(7), October...
Hello! I would try the following:
RETURNSUMX( 'Calendar Master',
IF( MAX( 'Calendar Master'[Fiscal month num])IN(1,4,7,10), DIVWEEKS*5, DIVWEEKS*4)
)If that doesn't work, I'd try checking the filters applied to the sheets and visuals.
Best regards!
Hello! I would try the following:
RETURN
SUMX( 'Calendar Master',
IF( MAX( 'Calendar Master'[Fiscal month num])IN(1,4,7,10), DIVWEEKS*5, DIVWEEKS*4)
)
If that doesn't work, I'd try checking the filters applied to the sheets and visuals.
Best regards!