User Profile
ptalanki
New Member
Joined 8 years ago
User Widgets
Contributions
Function 'DATESMTD' is not supported in DirectQuery mode
Function 'DATESMTD' is not supported in DirectQuery mode in filters in Report Server version Enabling allow unrestricted measures in directquery mode option did not work. Below is our DAX query - MTD_Avg_Balance_Debt = TOTALMTD([Sumprin Debt],v_get_TransDate[TransDate])/(DATEDIFF(STARTOFMONTH(v_get_TransDate[TransDate]),max(v_get_TransDate[TransDate]),DAY)+1) Works on desktop version, however doesnt work once published to sever.
