Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |