Forum Discussion

KaroRoza's avatar
KaroRoza
Helper I
5 months ago
Solved

FY data for each month

Hi,  please help on that as I still can not get results which I expect to see. This is very simple one dataset. I have sales records for all months (now 1-2.2026) and Targets for each month of 2026...
Need Help
  • KaroRoza's avatar
    KaroRoza
    5 months ago

    finally I found solution by mysleft

    BP26 GOR USD FY =
        SUMX(ALL(DATABASE),DATABASE[BP26 GOR USD])
KaroRoza's avatar
KaroRoza
Helper I
5 months ago

there is just one simple dataset with date column, month integer. There is no Dates table.

KaroRoza's avatar
KaroRoza
Helper I
5 months ago

finally I found solution by mysleft

BP26 GOR USD FY =
    SUMX(ALL(DATABASE),DATABASE[BP26 GOR USD])