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
some_bih's avatar
some_bih
Community Champion
1 year ago

Hi ERICCFG it could be that you have standard calendar and fiscal calendar data at same time, or more complex two general ledgers - pure accounting and fiscal one. If yes, check link for usage and creation of fiscal calendar in Power BI.

ERICCFG's avatar
ERICCFG
Frequent Visitor
1 year ago