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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Raj341
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

Raj341_0-1714417985113.png

PowerBI:

Raj341_2-1714418310655.png

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

3 REPLIES 3
Raj341
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 🙂

VijayP
Super User
Super User

@Raj341 

VijayP_0-1714452855313.gif

 

 

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!


amitchandak
Super User
Super User

@Raj341 , I have solved a very similar problem here

Select data between months - https://youtu.be/nEt7dT3Tfv4

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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