Hello all!
Here's the data I'm trying to calc the previous months (February) data based on these distinct columns:
Thank you!!
Solved! Go to Solution.
Thank you, gave that one a shot but wasn't quite what I was looking for. I'd been working on this seperately with this formula and got to what I needed, not sure if this is efficient?...
New Column =
CALCULATE(
SUMX(
DISTINCT (Table'[ID]), CALCULATE(MAX('Table'[Amount]))),
DATESINPERIOD('Table'[Created Date],MAX('Table'[Created Date]),-30,DAY))
Hi @lw24
please try
NewColumn =
VAR T1 =
CALCULATETABLE (
'Table',
ALLEXCEPT (
'Table',
'Table'[File Date],
'Table'[Name],
'Table'[ID],
'Table'[Created Date]
)
)
VAR T2 =
FILTER (
T1,
FORMAT ( 'Table'[File Date], "YYMM" ) = FORMAT ( 'Table'[Created Date], "YYMM" )
)
RETURN
MAXX ( T, 'Table'[Amount] ) + 0
Thank you, gave that one a shot but wasn't quite what I was looking for. I'd been working on this seperately with this formula and got to what I needed, not sure if this is efficient?...
New Column =
CALCULATE(
SUMX(
DISTINCT (Table'[ID]), CALCULATE(MAX('Table'[Amount]))),
DATESINPERIOD('Table'[Created Date],MAX('Table'[Created Date]),-30,DAY))
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!