Forum Discussion
Open Balance e Final Balance daily
- 9 years ago
Hi, RogerioTortosa
Please try this mearsure "test". I used the two columns "open_bank" and "close_bank" of table "dimTipFlu" as feature. You can try this directly.
Test =
IF (
DAY ( MIN ( dimCalendario[data] ) ) = 1,
IF (
MIN ( dimTipFlu[Open_Bank] ) = 1,
SUM ( fatMovi[vlrmovi] ),
IF (
MIN ( dimTipFlu[Close_Bank] ) = 1,
CALCULATE ( SUM ( fatMovi[vlrmovi] ), ALL ( dimTipFlu ) ),
SUM ( fatMovi[vlrmovi] )
)
),
IF (
MIN ( dimTipFlu[Open_Bank] ) = 1,
CALCULATE (
TOTALMTD ( SUM ( fatMovi[vlrmovi] ), PREVIOUSDAY ( dimCalendario[data] ) ),
ALL ( dimTipFlu )
),
IF (
MIN ( dimTipFlu[Close_Bank] ) = 1,
CALCULATE (
TOTALMTD ( SUM ( fatMovi[vlrmovi] ), dimCalendario[data] ),
ALL ( dimTipFlu )
),
SUM ( fatMovi[vlrmovi] )
)
)
)
Hi, RogerioTortosa
Please try this mearsure "test". I used the two columns "open_bank" and "close_bank" of table "dimTipFlu" as feature. You can try this directly.
Test =
IF (
DAY ( MIN ( dimCalendario[data] ) ) = 1,
IF (
MIN ( dimTipFlu[Open_Bank] ) = 1,
SUM ( fatMovi[vlrmovi] ),
IF (
MIN ( dimTipFlu[Close_Bank] ) = 1,
CALCULATE ( SUM ( fatMovi[vlrmovi] ), ALL ( dimTipFlu ) ),
SUM ( fatMovi[vlrmovi] )
)
),
IF (
MIN ( dimTipFlu[Open_Bank] ) = 1,
CALCULATE (
TOTALMTD ( SUM ( fatMovi[vlrmovi] ), PREVIOUSDAY ( dimCalendario[data] ) ),
ALL ( dimTipFlu )
),
IF (
MIN ( dimTipFlu[Close_Bank] ) = 1,
CALCULATE (
TOTALMTD ( SUM ( fatMovi[vlrmovi] ), dimCalendario[data] ),
ALL ( dimTipFlu )
),
SUM ( fatMovi[vlrmovi] )
)
)
)
I've a question.
I said that you created two columns.
But I don't understand why.