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.
Hi Team,
I have a requirement first half of the year my cost will remain same, but later secound half of the year my cost should add 6th month cost.
Ex : month Cost
1 23
2 21
3 20
4 33
5 12
6 15
7 12+15
8 11+15
9 09+15
10 14+15
11 24+ 15
12 26+15
Above example is just a dummy please let me know if this is possbile.
Solved! Go to Solution.
Hi Amit,
I tried with both like creating Measure and column also but i am getting same error.
Hi @Naveen_SV
Please create a new column with below code. PBIX is attached.
new cost =
IF (
'Table'[Month] > 6,
MAXX ( FILTER ( 'Table', 'Table'[Month] = 6 ), 'Table'[Cost] ) + 'Table'[Cost],
'Table'[Cost]
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Naveen_SV
Please create a new column with below code. PBIX is attached.
new cost =
IF (
'Table'[Month] > 6,
MAXX ( FILTER ( 'Table', 'Table'[Month] = 6 ), 'Table'[Cost] ) + 'Table'[Cost],
'Table'[Cost]
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Amit,
Can you send me pbi file please it will help
@Naveen_SV , try new column like
new column =
var _cost = maxx(filter(Table, [Year] =earlier([Year]) && [Month] =6), [Cost])
return
if([Month] >6 , _cost + [Cost], [Cost])
HI Amit,
thanks for your reply, i don't have this year column but i have only month in number, when i tried your
formuale i am getting this error pleas find the below table
<pi>A circular dependency was detected: Invoice[Running total].</pi>
@Naveen_SV , Try like
new column =
var _cost = maxx(filter(Table, [Month] =6), [Cost])
return
if([Month] >6 , _cost + [Cost], [Cost])
Hi Amit,
I tried with both like creating Measure and column also but i am getting same error.
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |