Here's the data I'm trying to calc the previous months (February) data based on these distinct columns:
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 =
DISTINCT (Table'[ID]), CALCULATE(MAX('Table'[Amount]))),
DATESINPERIOD('Table'[Created Date],MAX('Table'[Created Date]),-30,DAY))
View solution in original post
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" ))RETURNMAXX ( T, 'Table'[Amount] ) + 0
the logic is not very clear. could you elaborate it?
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.