Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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
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.
Hi ,
Can we filter out Type in Measure itself ?
I got the solution .
Thanks.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |