Forum Discussion
Cumulative week for Null values
Need Help
I have this 3 Indicators, “Saldo Inicial Semana” is how the week Star before include the week movements. This is working ok, but my problema is when a Week Don´t contains values, so “Saldo Inicial Semana” get null.
Formula:
Saldo Inicial Semana = Var LNBD=FIRSTNONBLANK(ALL('Cat Tiempo'[Fecha].[Date]),'Indicadores Bancos'[Suma Total Bancos]) Return
CALCULATE( 'Indicadores Bancos'[Suma Total Bancos], FILTER (ALL('Cat Tiempo'), 'Cat Tiempo'[Fecha].[Date]<LNBD))
I tried with this formula too
Saldo Inicial Semana = IF(NOT(ISBLANK(CALCULATE(SUM('Indicadores Bancos'[Total_Bancos])))),
CALCULATE(
SUM('Indicadores Bancos'[Total_Bancos]),
FILTER(
ALL('Cat Tiempo'),
'Cat Tiempo'[Fecha] < Min('Cat Tiempo'[Fecha]) ) ))
3 Replies
Hi Victor this is the file
Thanks so much
Mike
Hi MiguelSaldana77,
Since you need to use slicer selection 'Cat Tiempo'[Fecha] to filter matrix, and in matrix, the measure will calculate values according to current context. So, under some specifc week number and specific 'Cat Compañias'[Compañía], there is no corresponding date records, so, the measure cannot generate values. So, the matrix displays blank.
Regards,
Yuliana Gu
