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

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

Anonymous — Tue, 24 Nov 2020 14:55:23 GMT

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

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

edhans — Tue, 24 Nov 2020 15:50:01 GMT

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

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

Anonymous — Tue, 24 Nov 2020 16:06:04 GMT

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

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

amitchandak — Wed, 25 Nov 2020 02:16:05 GMT

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

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

Anonymous — Wed, 25 Nov 2020 15:48:49 GMT