Forum Discussion
dyanmic date parameters
Hi i have a report of ssrs, this is the query i want to implement it in power bi, i mean the parameter of dates SELECT * FROM TableA WHERE [Date] >=@StartApproveddate AND [Date]<=CASE WHEN ...
thanks
i have a project in visual studio-tabular model , do i need to write dax instead power query?
Hi inonb ,
If you connect with live connection, it is not supported to create parameters. If you use the import mode, I think using DAX formulas or using M language in Query Editor to transform data is based on your requirement. However, if we write with DAX, the formulas and the results will be not shown in Query Editor.
(Note: we only can create parameters in Query Editor.)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.