Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Its a live connection. Can't do any changes in Power query. Need a DAX measure for same.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi Anonymous ,

 

can you share a screenshot of the table from the Power BI model view?