Sum of values for the next month

lucianomagalhae — Sun, 24 Mar 2024 21:00:51 GMT

I have a table with the following columns

I need to put a wave matrix visual for each product, the value in the January column will be the value of the first date in February, in February it will be the value of the first date in March. In other words, the value in each month will always be the value of the first date of the following month. How could I do?

Re: Sum of values for the next month

Anonymous — Mon, 25 Mar 2024 02:28:49 GMT

Hi lucianomagalhae

Based on your question, here is my proposed method.

However, since your date column is broken down to days. Therefore the results may be somewhat different from your expectations.

Here's some dummy data

"Table"

Create a measure.

Measure = var _month = MONTH(SELECTEDVALUE('Table'[Date])) RETURN CALCULATE(MIN('Table'[Value]), FILTER( ALL('Table'), MONTH('Table'[Date]) = _month + 1 && 'Table'[Product] = MAX('Table'[Product]) ) )

Create a matrix.

Here is the result.

Regards,

Nono Chen

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

topic Re: Sum of values ​​for the next month in DAX Commands and Tips

Sum of values ​​for the next month

Re: Sum of values ​​for the next month

topic Re: Sum of values for the next month in DAX Commands and Tips

Sum of values for the next month

Re: Sum of values for the next month