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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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

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

4 REPLIES 4
amitchandak
Super User
Super User

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

Anonymous
Not applicable

PowerBI.png

edhans
Super User
Super User

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
Anonymous
Not applicable

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors