dax aas sum of other measure on date level

[antonio_wurth]

hi folks

need help with formula

i have inventory transaction table (income-outcome)

and in aas use 

movement_pcs:= sum('fact_transactions'[quantity])

and for inventory for date use:

inventory, pcs:=

VAR MaxDate = Max ('Calendar'[date_id])

VAR Result = 

    CALCULATE(

        [movement_pcs],

        'Calendar'[date_id]<= MaxDate,

        ALL('Calendar')

    )

return

    Result

question:

i need new measure which give me sum for each date in selected/active period

Mar 2025 -> sum of selected dates in march

Feb 2025 -> sum of selected dates in feb

Year 2025 level -> sum of Mar and Feb dates

thank you in advance

[v-yangliu-msft]

Hi  @antonio_wurth ,

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
DISTINCT('Table'[Month])

2. Create measure.

Measure =
var _select=SELECTCOLUMNS('Table 2',"test",[Month])
RETURN
IF(
    ISINSCOPE('Table'[Year]),SUM([inventory,pcs]),SUMX(FILTER(ALL('Table'),'Table'[Month] in _select),[inventory,pcs]))

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[antonio_wurth]

dax aas sum of other measure on date level

6m ago

hi folks

need help with formula

i have inventory transaction table (income-outcome)

and in aas use 

movement_pcs:= sum('fact_transactions'[quantity])

and for inventory for date use:

inventory, pcs:=

VAR MaxDate = Max ('Calendar'[date_id])

VAR Result = 

    CALCULATE(

        [movement_pcs],

        'Calendar'[date_id]<= MaxDate,

        ALL('Calendar')

    )

return

    Result

question:

i need new measure which give me sum for each date in selected/active period

Mar 2025 -> sum of selected dates in march

Feb 2025 -> sum of selected dates in feb

Year 2025 level -> sum of Mar and Feb dates

thank you in advance