Forum Discussion
ApurvaKhatri
8 years agoHelper III
Get value for previous month
Data GroupingPoint GroupingCount GroupingDate EndOfPeriod 50 2017-08-31 EndOfPeriod 45 2017-07-31 EndOfPeriod 49 2017-06-30 EndOfPeriod 54 2017-05-31 EndOfPeriod 58 2017-04-30 EndOfPeriod 5...
- 8 years ago
Hi ApurvaKhatri
Add this calculated column
PreviousMonthCount = VAR Previous_Month = MAXX ( FILTER ( Table1, Table1[GroupingDate] < EARLIER ( Table1[GroupingDate] ) ), Table1[GroupingDate] ) RETURN CALCULATE ( SUM ( Table1[GroupingCount] ), FILTER ( Table1, Table1[GroupingDate] = Previous_Month ) ) - 8 years ago
Hi ApurvaKhatri
Alternatively, you could use a "MEASURE" as well
PreviousMonthCount = VAR Previous_Month = MAXX ( FILTER ( ALL ( Table1 ), Table1[GroupingDate] < VALUES ( Table1[GroupingDate] ) ), Table1[GroupingDate] ) RETURN IF ( HASONEVALUE ( Table1[GroupingDate] ), CALCULATE ( VALUES ( Table1[GroupingCount] ), FILTER ( ALL ( Table1 ), Table1[GroupingDate] = Previous_Month ) ) )
Zubair_Muhammad
8 years agoCommunity Champion
Hi ApurvaKhatri
Add this calculated column
PreviousMonthCount =
VAR Previous_Month =
MAXX (
FILTER ( Table1, Table1[GroupingDate] < EARLIER ( Table1[GroupingDate] ) ),
Table1[GroupingDate]
)
RETURN
CALCULATE (
SUM ( Table1[GroupingCount] ),
FILTER ( Table1, Table1[GroupingDate] = Previous_Month )
)Zubair_Muhammad
8 years agoCommunity Champion
Hi ApurvaKhatri
Alternatively, you could use a "MEASURE" as well
PreviousMonthCount =
VAR Previous_Month =
MAXX (
FILTER (
ALL ( Table1 ),
Table1[GroupingDate] < VALUES ( Table1[GroupingDate] )
),
Table1[GroupingDate]
)
RETURN
IF (
HASONEVALUE ( Table1[GroupingDate] ),
CALCULATE (
VALUES ( Table1[GroupingCount] ),
FILTER ( ALL ( Table1 ), Table1[GroupingDate] = Previous_Month )
)
)