How to compare text columns values between multipl...

awasthi1984 · ‎11-24-2020

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

amitchandak · ‎11-24-2020

@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!

awasthi1984 · ‎11-25-2020

edhans · ‎11-24-2020

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

awasthi1984 · ‎11-24-2020

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

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

Helpful resources

Congratulations!

Check out the updates in Power BI.

Microsoft Ignite

The largest Power BI virtual conference