Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
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.
Thanks for the reply.
Can you please tell me how to use DAX in my above example?
Regards,
Kaushik
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.