Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

How to compare text columns values between multiple dates in one data set using Power BI DAX

‎11-24-2020 06:55 AM

Hi,

I want to compare text values of a particular column between two dates in the same dataset using Power BI DAX and find out for which values the status has been moved from the selected dates and display it as a comma separated value in the dashboard

Thanks & Regards
Shobhit

Message 1 of 5
1,740 Views
0
4 REPLIES 4
amitchandak
Super User
Super User

‎11-24-2020 06:16 PM

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 4 of 5
1,679 Views
0
Anonymous
Not applicable
In response to amitchandak

‎11-25-2020 07:48 AM

PowerBI.png

Message 5 of 5
1,651 Views
0
edhans
Super User
Super User

‎11-24-2020 07:50 AM

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 2 of 5
1,713 Views
0
Anonymous
Not applicable
In response to edhans

‎11-24-2020 08:05 AM

Hi edhans,

 

We can select any date from the date slicer therefore we need to write DAX and do the comparison on the fly to find out how many values exists and how many values moved from the selected date

 

Thanks & Regards

Shobhit

Message 3 of 5
1,701 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All