Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |