Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Power Users,
I'm trying to create a measure or calculation for Monthly difference. but not getting exactly what i need. Basically what i'm trying to do get the difference for Amount for each Milestone number & Date.
I have create a previous month measure like calculate (Sum(Amount), Prevousmonth(Date) that gives me the previous month amount and i'm just subtracting amount-previousmonth amount to the difference. If you observe in the data there is no data for march for 123 in that i would like get the difference Feb to Apr. it should be like 200-400 but in my logic there is no data for march then it considers as 0 then its give me 200-0.
Please help.
Solved! Go to Solution.
Hi, @corpsikumar
You can try the following methods.
Preamount =
VAR PreDate =
MAXX (
FILTER (
ALL ( 'Table'[Entry_Date], 'Table'[Milestonenumber] ),
[Entry_Date] < SELECTEDVALUE ( 'Table'[Entry_Date] )
&& [Milestonenumber] = SELECTEDVALUE ( 'Table'[Milestonenumber] )
),
'Table'[Entry_Date]
)
VAR Preamount =
CALCULATE (
SUM ( 'Table'[amount] ),
FILTER (
ALL ( 'Table' ),
[Entry_Date] = PreDate
&& [Milestonenumber] = SELECTEDVALUE ( 'Table'[Milestonenumber] )
)
)
RETURN
Preamount
Difference = IF([Preamount]<>BLANK(),[Preamount]-SUM('Table'[amount]))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @corpsikumar
You can try the following methods.
Preamount =
VAR PreDate =
MAXX (
FILTER (
ALL ( 'Table'[Entry_Date], 'Table'[Milestonenumber] ),
[Entry_Date] < SELECTEDVALUE ( 'Table'[Entry_Date] )
&& [Milestonenumber] = SELECTEDVALUE ( 'Table'[Milestonenumber] )
),
'Table'[Entry_Date]
)
VAR Preamount =
CALCULATE (
SUM ( 'Table'[amount] ),
FILTER (
ALL ( 'Table' ),
[Entry_Date] = PreDate
&& [Milestonenumber] = SELECTEDVALUE ( 'Table'[Milestonenumber] )
)
)
RETURN
Preamount
Difference = IF([Preamount]<>BLANK(),[Preamount]-SUM('Table'[amount]))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |