How to compare text columns values between multipl...

Anonymous · ‎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

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

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Anonymous · ‎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

Anonymous · ‎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

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024