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 ...
Hi inonb ,
I add a blog that you can reference. The entire blog does not meet your requirement exactly. However, you can reference the Parameter part to understand how to create and use it.
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
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.
thanks
i have a project in visual studio-tabular model , do i need to write dax instead power query?