Forum Discussion
Helper IIITotals for year showing wrong value
Resident RockstarHI MrMP ,
Can you please share the measures you use for the columns?
Best regards
Michael
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
MrMP1. Balance Sheet Field -
VAR lastquarter = MAX('Calendar'[Quarter Number]) VAR lastyear = MAX('Calendar'[Year]) RETURN SWITCH(TRUE(), ISINSCOPE('Calendar'[Quarter Number]), Sum(Balance Sheet Field), ISINSCOPE('Calendar'[Year]), CALCULATE(Sum(Balance Sheet Field)), FILTER('Calendar','Calendar'[Quarter Number]=lastquarter && 'Calendar'[Year]=lastyear)))2. PnL Field -
SWITCH(TRUE(), ISINSCOPE('Calendar'[Quarter Number]),Sum(Revenue Field) , ISINSCOPE('Calendar'[Year]),SUMX(SUMMARIZE('Calendar','Calendar'[Year],'Calendar'[Quarter Number]),sum(Revenue Field) ), SUMX(SUMMARIZE('Calendar','Calendar'[Year],'Calendar'[Quarter Number]),sum(Revenue Field) ))Lowest granularity of the calendar is Quarter.
Thank you!!!
- Mikelytics
Hi MrMP
Can you please try to build a third measure like the following?
Result = SUMX( VALUES('Calendar'[Quarter Number]), [PnL Field] + [Balance Sheet Field] )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
- MrMP