topic Re: Sum pending values with based on the previous month in DAX Commands and Tips

Sum pending values with based on the previous month

flaviobdsti — Thu, 15 Dec 2022 19:18:19 GMT

Hi guys,

I'm trying to create a measure that shows me the sum of outstanding amounts in the current month based on the amounts that occurred in the previous month. I need to put this total amount on the card. Can you help me, please?

Re: Sum pending values with based on the previous month

vicky_ — Thu, 15 Dec 2022 21:53:09 GMT

Is there any reason you can't do SUM(January) - SUM(February)?

Re: Sum pending values with based on the previous month

flaviobdsti — Fri, 16 Dec 2022 02:26:38 GMT

It doesn't work because Jan (last month) and Feb (current month) are measured:

Current month = CALCULATE(SUM(BillsReceive[value_document]),GROUPBY(dimIDJ,dimIDJ[IDJ]))

Last month = CALCULATE([Current month],DATEADD(dimCalendar[Date],-1,MONTH))

I get the desired result only when I add the measures in a table and configure a filter on the screen for the current month (feb) = blank()

But I need to be able to do this in a measure to add to a card

Re: Sum pending values with based on the previous month

v-zhangti — Fri, 16 Dec 2022 08:52:16 GMT

Hi, flaviobdsti

You can try the following methods.

Measure:

JAN = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),MONTH([Date])=1&&[ID]=SELECTEDVALUE('Table'[ID])))

FEB = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),MONTH([Date])=2&&[ID]=SELECTEDVALUE('Table'[ID])))

Measure = SUMX(FILTER(ALL('Table'),[FEB]=BLANK()&&MONTH([Date])=1),[JAN])

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

Re: Sum pending values with based on the previous month

flaviobdsti — Fri, 16 Dec 2022 20:02:46 GMT

Thanks a lot for the precious help.