Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have Sales Value from FactSales.
I tried to calculated Sales Value 6 month ago based on Month slicer selection.
My output table looks like,
Let's say the selected month is Oct 2018
Product | Sales-Oct 2018 | Sales-May 2018 |
Please assist me to achieve this.
Hi @SivaMani
You may refer to below post to get the measure.
DAX formula compatibility in DirectQuery mode
Regards,
Cherie
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |