How can we show Previous month Amount in card segregrated by different types ?

[Anonymous]

Hi ,

How can we show Previous month Amount in card segregrated by different types ?

Here example : Last month - September contains different types professional services, network connectivity , others , Taxes , Support services charges , software charges should show amount of each type in different cards.

Any help would be appreciated.

[sturlaws · Accepted solution]

Create this measure

previous month amount=
VAR _prevMonth =
    CALCULATE (
        MAX ( 'Table'[Month] );
        FILTER ( ALL ( 'Table'[Month] ); 'Table'[Month] < TODAY () )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Amount] );
        FILTER ( ALL ( 'Table'[Date] ); 'Table'[Month] = _prevMonth )
    )

This measure will work for all of the types. Just create the correct number of cards, and for each of them drag the Type-field into the filter-section of the visual and filter each of the visuals for a type.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

then add it to a card visual. In the filter pane of the visual, drag in the Type-field and filter the visual for one of the types.

[sturlaws]

Hi@Anonymous,

Do you want to have a card visual of previous month amount, and be able to filter it by Type? Or one card for each type?

Cheers,
Sturla

[Anonymous]

Yes ,  card visual of previous month amount and one card of each type

[sturlaws · Accepted solution]

Create this measure

previous month amount=
VAR _prevMonth =
    CALCULATE (
        MAX ( 'Table'[Month] );
        FILTER ( ALL ( 'Table'[Month] ); 'Table'[Month] < TODAY () )
    )
RETURN
    CALCULATE (
        SUM ( 'Table'[Amount] );
        FILTER ( ALL ( 'Table'[Date] ); 'Table'[Month] = _prevMonth )
    )

This measure will work for all of the types. Just create the correct number of cards, and for each of them drag the Type-field into the filter-section of the visual and filter each of the visuals for a type.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

then add it to a card visual. In the filter pane of the visual, drag in the Type-field and filter the visual for one of the types.

[Anonymous]

Hi ,

Can we filter out Type in Measure itself ?

[Anonymous · Accepted solution]

I got the solution .

Thanks.