Forum Discussion

Azou's avatar
Azou
Regular Visitor
2 years ago

Daxe issue

Hi, I need help with a DAX issue. I have a table with the following columns: YEAR MONTH, ACTUALS, and FORECAST. The YEAR MONTH table is composed as follows: 23-01; 23-02; ... ; 23-12 ; 23-01; 23-02; ...
JamesFR06's avatar
JamesFR06
Resolver IV
2 years ago

HI

Measure=

var Lastdatewithactuals= CALCULATE(max(MasterFacts[StartDate]),MasterFacts[Scenario]="Actuals")

 

Var Act = CALCULATE(sum(MasterFacts[Value]),MasterFacts[Scenario]="Actuals")
Var Fcst = CALCULATE(sum(MasterFacts[Value]),MasterFacts[Scenario]="Forecast")

VAR RemainingForecast =

    CALCULATE (

        [Fcst],

        KEEPFILTERS ( MasterFacts[Value] > Lastdatewithactuals)

var Actualandforecast=Act+Remainingforecast

return 

calculate(Actualandforecast,datesytd(date[date]))

Azou's avatar
Azou
Regular Visitor
2 years ago

Hi, thanks for your reply. Yes, the formula you sent me works well but it comes out of LE MTD in my table. What I want is to have a new measure column that will have as its value the sum that I have framed in red on the image load previously

  • JamesFR06's avatar
    JamesFR06
    Resolver IV
    2 years ago

    Hi,

    The measure I sent you id oding actuals and forecast. Please check

    • Azou's avatar
      Azou
      Regular Visitor
      2 years ago

      Salut, Oui désolé. C’est vrai, mais j’avais déjà calculé cette mesure. Je ne sais pas si vous avez compris ma question sur le post précédent.

      • JamesFR06's avatar
        JamesFR06
        Resolver IV
        2 years ago

        Donc elle fonctionne, normalement elle prend les actuals jusqu'au dernier jour ensuite elle ajoute le forecast