Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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




VAR _startdate = SELECTEDVALUE(StartDate[RUN_DATE], BLANK())
var _Rundate = SELECTCOLUMNS('Table','Table'[RUN_DATE])
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

Frequent Visitor

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 🙂

Super User
Super User





Are you looking for this?


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Super User
Super User

@Raj341 , I have solved a very similar problem here

Select data between months -

Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.