Forum Discussion

kilala's avatar
kilala
Resolver I
3 years ago
Solved

Calculation based on different accounting date

Hi I have created 1 measure to calculate YTD amount for 3 division, (1,2,3). However, these 3 division might have different accounting date compared to our normal date. So, in my dimdate, i hvae 4 co...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi kilala,

    I'd like to suggest you add segmentation table with these division and correspond date ranges.

    Then you can map these divisions to your table records and write formula to calculate based on current division.(use current division to search on the segmentation table date range to filter in the formula calculations)

    Dynamic segmentation – DAX Patterns

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi kilala,

I'd like to suggest you add segmentation table with these division and correspond date ranges.

Then you can map these divisions to your table records and write formula to calculate based on current division.(use current division to search on the segmentation table date range to filter in the formula calculations)

Dynamic segmentation – DAX Patterns

Regards,

Xiaoxin Sheng