Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |