Forum Discussion

inonb's avatar
inonb
Frequent Visitor
6 years ago

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 ...
Need Help
inonb's avatar
inonb
Frequent Visitor
6 years ago

thanks

 

i have a project in visual studio-tabular model , do i need to write dax instead power query?

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    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.

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi inonb ,

    Did you implement it? If yes, please mark the helpful answer as a solution. Welcome to share your own solutions. More people will benefit here.

     

    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.