Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created MOM% DAX measure and used it in a table visual to see % change in sales. How can I make sure it only calculates when current month sales is present?
In my case I don't want to see MOM% April month in the table. How can I achieve that?
Solved! Go to Solution.
Hi,
Please try something like below whether it suits your requirement.
MoM% =
VAR __PREV_MONTH =
CALCULATE (
[Total Sales],
DATEADD ( 'WalmartSQL repository'[dtme].[Date], -1, MONTH )
)
RETURN
IF ( [Total Sales], DIVIDE ( [Total Sales] - __PREV_MONTH, __PREV_MONTH ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please try something like below whether it suits your requirement.
MoM% =
VAR __PREV_MONTH =
CALCULATE (
[Total Sales],
DATEADD ( 'WalmartSQL repository'[dtme].[Date], -1, MONTH )
)
RETURN
IF ( [Total Sales], DIVIDE ( [Total Sales] - __PREV_MONTH, __PREV_MONTH ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |