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 of reply

Can you send me link of example

 

 

JirkaZ's avatar
JirkaZ
Icon for Solution Specialist rankSolution Specialist
6 years ago

inonb First of all you have to create the start and end date parameters in query editor (of DATE type). 

Then the query itself would look something like:

 

let
   EndDateDW = Date.DayOfWeek(EndDate),
   EndDateAdjusted = if (EndDateDW = 4 or EndDateDW = 5) then Date.AddDays(EndDate, EndDateDW - 1) else    Date.AddDays(EndDate, 2),

//Now you can use the StartDate and EndDate params in your query
   Source = ""
in
   Source