Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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.

vmware-view_2019-11-07_16-45-27.png

 

Any help would be appreciated.

2 ACCEPTED SOLUTIONS

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.

View solution in original post

Anonymous
Not applicable

I got the solution .

 

Thanks.

View solution in original post

5 REPLIES 5
sturlaws
Resident Rockstar
Resident Rockstar

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
Not applicable

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

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
Not applicable

Hi ,

 

Can we filter out Type in Measure itself ?

Anonymous
Not applicable

I got the solution .

 

Thanks.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.