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,
I need help to solve the following problem. I have created 2 measures (M1 and M2). I would like to create another measure (Result) where I can add the last value of M2 (value from year 2011) to all the values of M1 (starting from 2012). My desired result would be "Result" but I get the "Bad-Result" as final result which I gained from simply doing:
[M1] + [M2]
If I have a simple value e.g. 2 the above formula works: 2 + [M1] gives me: 7 ,9 , 5, 6 starting from year 2012. But this doesn't work if I add up 2 measures.
Please help. Thank you in advance.
@SEZA , Try a measure like
measure =
var _max = maxx(filter(values(Table[Year]), not(isblank([M2]))), Table[Year])
return
calculate([M2], filter(all(Table), Table[Year] =_max)) +[M1]
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
10 | |
7 |