Use slicer to filter multiple column

[kaushikhalvadia]

Hi, I am a beginner and learning Powerbi. I'm creating this is 3rd report 🙂 

Below is my SQL query for the report which gives me the expected and accurate output. 

Now, I want to pass the StartDate and EndDate values from the slicer(Between types)

Can someone please tell me how to achieve this?

PS. I can pass and fetch date columns/parameters in any format. Currently, I have passed the dates as varchar.

Thanks for your help!

[v-yalanwu-msft]

Hi, @kaushikhalvadia ;

Sorry, can you share a scene and the result you want to output? So that I can better use DAX testing.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @kaushikhalvadia ;

As far as I know, you can use DAX to implement, Power BI has data processing functions and dynamic display of results, if you can share a simple example (scenario) and hope to output the result it is better, in order to solve your problem faster.
Looking forward to your reply!

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kaushikhalvadia]

Hi @v-yalanwu-msft 

Thanks for the reply.

Can you please tell me how to use DAX in my above example?

Regards,

Kaushik