The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Trying to create a DAX command using this function.
My data is as follows:
The Month column is formatted as Date.
If I take out the SAMEPERIODLASTYEAR element it returns the value for the current month OK. But as soon as I add in SAMEPERIODLASTYEAR it returns a blank field.
Can anybody see what I'm doing wrong here?
Solved! Go to Solution.
hi @Fusilier
try like:
Prev Year =
CALCULATE(
SUM(data[Incident]),
FILTER(
ALL(data),
data[month]=EDATE(EARLIER(data[Month]), -12)
),
ALLEXCEPT(data, data[Location])
)
or
Prev Year2 =
SUMX(
FILTER(
data,
data[month]=EDATE(EARLIER(data[month]), -12)
&&data[location]=EARLIER(data[location])
),
data[Incident]
)
it worked like:
Apologies, my fault. Solution 2 works like a dream!
THANK YOU!
hi @Fusilier
try like:
Prev Year =
CALCULATE(
SUM(data[Incident]),
FILTER(
ALL(data),
data[month]=EDATE(EARLIER(data[Month]), -12)
),
ALLEXCEPT(data, data[Location])
)
or
Prev Year2 =
SUMX(
FILTER(
data,
data[month]=EDATE(EARLIER(data[month]), -12)
&&data[location]=EARLIER(data[location])
),
data[Incident]
)
it worked like:
User | Count |
---|---|
26 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |