Segmentation by month value and the next

[Syndicate_Admin]

I have a table with values by month, by year and by city. I want to segment by month and visualize (card) the different values

, but I also want the values for the month following the segmented to be displayed on other cards. how can it be done?. Thank you

[Syndicate_Admin]

Any ideas?

[v-henryk-mstf]

Hi @Syndicate_Admin ,

Can you provide test data, I will answer you as soon as possible.

Best Regards,
Henry

[v-henryk-mstf]

Hi @Syndicate_Admin ,

Try the measure like this to get result group by month：

Measure = CALCULATE(SUM('Table'[valor0]),ALLEXCEPT('Table','Table'[mes])

If i misunderstand what you mean, can you further provide detailed demand information and expected results screenshots, I will answer you as soon as possible.

Best Regards,
Henry

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

[Syndicate_Admin]

[v-henryk-mstf]

Hi @Syndicate_Admin ，

The picture is not clear, please upload again, thank you.

Best Regards,
Henry

[Syndicate_Admin]