Forum Discussion
Direct query mode logics
Dear champions,
Can anyone please suggest me whether it is possible to use parameters in slicer to filter the data in direct query mode? Because am not am able to achieve it.
and also one more thing could anyone please let us know how business hours logic works in direct query mode?
thanks in. Advance
Rockz , You need to consider the dynamic m parameter
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/
Use this but inside Sumx or averagex
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Example
Sumx(Table, <Business hour logic using columns>)
1 Reply
Rockz , You need to consider the dynamic m parameter
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
https://blog.crossjoin.co.uk/2020/10/25/why-im-excited-about-dynamic-m-parameters-in-power-bi/
Use this but inside Sumx or averagex
https://exceleratorbi.com.au/calculating-business-hours-using-dax/
Example
Sumx(Table, <Business hour logic using columns>)