topic Help in comparing values in a same column. in DAX Commands and Tips

Help in comparing values in a same column.

YogeshWaran2010 — Thu, 11 Jan 2024 11:56:03 GMT

Hi,

I am trying to achieve a result by comparing two rows in a column and show output based on a condition. I have shared a simple layout of the table on the below image ,

We are trying to achieve result similar to

As you can we need add a column with comparison both row data for different and If equal show "O" and not equal "X".

Thank you

Re: Help in comparing values in a same column.

Anonymous — Thu, 11 Jan 2024 03:58:35 GMT

Hi, YogeshWaran2010

here is my solution:

To achieve this effect, the table is mainly converted through the pivot column, and the corresponding effect is derived by comparing it using a DAX expression.

First step, we need to import data to power BI desktop , and click transform data :

And then, we click transform >> Pivot column:

Note: We need to select the date column and then click on the pivot column

And then, values column we select amount >> click OK. And then, we click close and apply：

And then, we click table view >> new column:

Now, We enter the DAX expression:

IF('Table 1 (Tabelle1)'[4/1/2023] = 'Table 1 (Tabelle1)'[12/1/2023], "O","X")

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Help in comparing values in a same column.

YogeshWaran2010 — Thu, 11 Jan 2024 04:15:40 GMT

Hi Anonymous ,

Thank you for your support. I can achieve my results using these steps.

I have some doubts, if we have multiple dates then this method would not be feasible right?

If we wish implement it in the actual data where we will be required to compare multiple dates is there any work around.

Thank you

Yogesh