dax functions

2 Topics

Power BI server (March 2018 released version) Direct Query CANNOT use built in DAX functions
Power BI server (March 2018 released version) Direct Query CANNOT use built in DAX functions such as SAMEPERIODLASTYEAR(), FIRSTDATE(), LASTDATE()... Any thoughts? Given that I don't want to use import mode.
JayZheng
8 years ago Place Report Server
2.2KViews
0likes
4Comments
Some dax functions does not work on PBRS
Hi all; Some functions does not work like dateadd,totalmtd,totalytd etc. in direct query mode And I wanna say everthing works at Power BI Desktop RS .The problem starts when I published to the Power BI Report Server. Also marked "Allow unrestricted measures in Direct query mode" Im getting MdxScript(Model) (19, 33) Function 'DATESMTD' is not supported in DirectQuery mode. MdxScript(Model) (13, 4) Function 'DATEADD' is not supported in DirectQuery mode. etc. errors. Which dax functions are working on Power BI Report Server?Is there any list of them? Thank you.
Solved
dagurkuden
8 years ago Place Report Server
7.5KViews
0likes
6Comments