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; ...
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

       

      • Azou's avatar
        Azou
        Regular Visitor
        2 years ago

        Yes. But that's not what I want right now