cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
awasthi1984
Frequent Visitor

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 IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

PowerBI.png

edhans
Super User III
Super User III

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

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors