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,
Can anyone help me to translate DAX query into M query.
I'm new to M query, need to implement this measure at M query.
SUM =
VAR A =
SWITCH(MONTH(SELECTEDVALUE(Ships[Fiscal Month])),3,-6,2,-5,1,-4,12,-3,11,-2,10,-1,9,-6,8,-5,7,-4,6,-3,5,-2,4,-1)
RETURN
CALCULATE(SUM(Ships[Shipments]),DATESINPERIOD(Ships[Fiscal Month],SELECTEDVALUE(Ships[Fiscal Month]),A,MONTH))
Thanks In Advance.
Regrads,
Pavan Vanguri.
Hi @Anonymous,
Could you please tell me the formula is a measure or a calculated column, I tried with the formula as calculated column, but it returns blank and if it is a measure, I am afraid you could not achieve the result. Could you please post me your desired result or share the pbix file if possible?
Regards,
Daniel He
User | Count |
---|---|
88 | |
88 | |
74 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |