Forum Discussion

Raj341's avatar
Raj341
Frequent Visitor
2 years ago

Date Range selection with two independent parameters

Hi @everyone
How to get the results of Date Range selection based on two independent parameters.
I have created two independent parameters 
1. Parameter_startdate - [distinct dates from the source]
2.Parameter_end date
3.Rundate -- column
I need to use the dax query to restrict the results based on date range.
I am sharing the image for reference, I build in tableau but not able to do in powerbi

PowerBI:

VAR _startdate = SELECTEDVALUE(StartDate[RUN_DATE], BLANK())
VAR _Enddate = SELECTEDVALUE(EndDate[RUN_DATE], BLANK())
var _Rundate = SELECTCOLUMNS('Table','Table'[RUN_DATE])
Return
I used many conditions but not able to achieve the correct results.
first calculation helps me to restrict the data with boolean conditions.
second calculation helps me to show the last 7 days trend.
Please help me to achieve this. I am eagerly waiting for response

Note: if possible please share workbook with me, it will help a lot 
-Thanks in advance

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Raj341's avatar
    Raj341
    Frequent Visitor
    2 years ago

    Hi VijayP amitchandak 
    in the above case we have to write the calculation for every single visual. but instead of that if we create a flags and keep it on the filter, it reduces number of calculations.
    In tableau those calculations we keep in filter shelf to filter the records.
    - please help me to fix it 🙂