Help in comparing values in a same column.

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.