Sage 300 date overlap problem.

[ERICCFG]

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 periods and that means that when we want to do a filter by period and year in a calendar, we end up with false sums of expenses or income. Is there anyone who has had the same problem and how they resolved this situation.

[some_bih]

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]

Yes I use fiscal calendar

[some_bih]

Hi @ERICCFG on link you can find standard calendar creation and fiscal year too. It also showing a lot of examples with measures, like sales fiscal year (search fiscal)

[ERICCFG · Accepted solution]

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]

Hi @ERICCFG great. If some of posts here helped you mark ita as solution, so other could see it.

[ERICCFG]

[some_bih]

@ERICCFG I do not understand your pictures, not famičiar wit descriptions, column names.

I hope you have Calendar/ Date table in your pbi file? 

[ERICCFG]

[v-zhouwen-msft]

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

[Rupak_bi]

• Hi @ERICCFG 
• Please share sample table and elaborate the issue