Forum Discussion

LuisCaston82's avatar
LuisCaston82
New Member
2 years ago
Solved

Switch and add a result

Dear all, I've this formula: Actual YTD + Forecast = var _YTD = CALCULATE([Amount], BIFRF000[Report] = "", BIFRF000[Period Type] = "T", BIFRF000[Type] = "V") var _Forecast = CALCULATE([...
Need Help
Tips and Tricks
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    2 years ago

    LuisCaston82 

    Please try this measure:

    Actual YTD + Forecast =
VAR _YTD =
    CALCULATE (
        [Amount],
        BIFRF000[Report] = "",
        BIFRF000[Period Type] = "T",
        BIFRF000[Type] = "V"
    )
VAR _Forecast =
    CALCULATE ( [Amount], BIFRF000[Report Type] = "T" )
RETURN
    IF ( _YTD = 0, _Forecast, _YTD )
Fowmy's avatar
Fowmy
Super User
2 years ago

LuisCaston82 

Please try this measure:

Actual YTD + Forecast =
VAR _YTD =
    CALCULATE (
        [Amount],
        BIFRF000[Report] = "",
        BIFRF000[Period Type] = "T",
        BIFRF000[Type] = "V"
    )
VAR _Forecast =
    CALCULATE ( [Amount], BIFRF000[Report Type] = "T" )
RETURN
    IF ( _YTD = 0, _Forecast, _YTD )