Forum Discussion
SQL to DAX conversion
How to convert below SQL query to a DAX measure. The 'date' case structure should be dymanic to get last 4 months data. select mnth,M1_Ord,M2_Ord,M3_Ord,M4_Ord,Is_cons_flg,count(outlet_id) out...
Hi Anonymous
Your SQL language is complex. Could you provide me with your data model and a screenshot of the result you want? And this will make it easier for me to understand your require.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.