Forum Discussion

ERICCFG's avatar
ERICCFG
Frequent Visitor
1 year ago
Solved

Sage 300 date overlap problem.

Hello, I have a date overlap problem. I have an accounting entry table (sage 300) where there is a date column, fiscal year, period etc. In some cases the accounting entry date is the same for two pe...
  • ERICCFG's avatar
    ERICCFG
    1 year ago

    thank you

     

    I found the solution,

     

    CALCULATE(
        SUM(GLACC[Valeur]),
        GLACC[Type] = "2-Dépense",
        TREATAS(VALUES(Calendrier[Période]), GLACC[Période]),
        TREATAS(VALUES(Calendrier[Année Fiscale]), GLACC[Année Fiscale]),
        ALL(Calendrier) -- Supprime le filtre sur la date
     
    Thnank you for the people, they write me
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ERICCFG ,

Can you give some simple examples? It should be possible to come up with the correct result by modifying dax.

In some cases the accounting entry date is the same for two periods and that means that when we want to do a filter by period and year in a calendar