The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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))
User | Count |
---|---|
24 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |