Forum Discussion
harshaSampath81
9 years agoHelper II
Is it Possible to do Dax Calculations when we use Direct Query ?
Can we perform calucations using DAX if we use DirectQuery in Power BI New Version ? Harsha
- 9 years ago
Thanks to All
v-huizhn-msft
9 years agoMicrosoft Employee
Hi harshaSampath81,
You can write some DAX functions even in Direct Query mode. You need to select File > Options and then Settings > Options and settings > DirectQuery, then selecting the option *Allow unrestricted measures in DirectQuery mode**. When that option is selected, any DAX expression that is valid for a measure can be used. The functions that are supported vary by data source, but Intellisense will prompt you with only the valid options are you enter your formulas.
Best Regards,
Angelia
harshaSampath81
9 years agoHelper II
Thanks to All