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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Jay12
New Member

Dax in Power BI Desktop

I have an issue:

I have:

1. IDs (this contains nvarchar ID)

2. Stage (This is the stage of each ID at different dates)

3. Import_Date: This is a date value for all ID.

 

I want to create a report to have:

2 date filters for Import_Date

 

A visual to show:

In column A: IDs

In column B: Early Stage only (This should contain only data for the minimum user selected date)

 

In column C: Later Stage only (This should contain only data for thr maximum user selected Date).

 

 

Basically, I want to view only data for the selected dates, not before or after the date. 

 

Example, if a user selects 6/10/2022 and 13/1/2023, the visual will show this pattern. 

ID-440 || Stage_7 || Stage_9

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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