我采用以下公式,但我没有像我所希望的那样获得变化:
DoD% de MB2200 =
VAR FechaElegida=SELECTEDVALUE(DIM_FECHAS[FCH_LABORABLE_ANT])
VAR __PREV_DAY =
CALCULATE(
SUM( DATAMATRIX [MB2200]),
DIM_FECHAS [FECHAID].[Date]=FechaElegida
)
RETURN
SUM( DATAMATRIX [MB2200]) - __PREV_DAY
To clarify I want to obtain the difference when I filter by the FECHAID (For example, for the date 29dec23 and fila_balance=11 DoD de MB2200 should be 569.09-567.82=1.27 but I have 569.09)
我有以下表格:
- DIM_FECHAS: FECHAID (date), FCH_LABORABLE_ANT(Previous working day)
- DATAMATRIX: FECHAID (date), MB2200(amount of which I want to obtain the difference with the previous working date), fila_balance(Identification of certain information)
提前感谢。