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.
Hi Experts,
please help me to acheive the below:
I tried hard but nothing is working.
I want to subtract the value = Dec-Jan = -16.28
Please help me on this.
Regards.,
Swamy
Hi @Swamy3105 ,
Thank you for @Syndicate_Admin answer , and I have other suggestions:
Below is my table:
The following DAX might work for you:
Column =
VAR _month = MIN('Table'[Year])
VAR _new_month = MONTH(EDATE(_month,1))
VAR _a = CALCULATE(MAX('Table'[FIFO]),FILTER('Table',MONTH('Table'[Year]) = _new_month))
VAR _b = CALCULATE(MAX('Table'[FIFO]),FILTER('Table',MONTH('Table'[Year]) = MONTH(_month)))
RETURN
_b - _a
The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks for your dax, but I need to subtract the value from current month to previous month as below:
Regards.,
Swamy
Nice
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |