DAX function that fills a column with one of my current values and leaves the rest of rows blank

[ase]

Hi all,

I don't even know how to explain my issue. I need a DAX function that will sort the Price for the month by product and leave all the other rows blank. 

Current data				Expected Result
	Product	Price for the month			Product	Price for the month
	Iphone 13	300			Iphone 13	300
	Iphone 13	300			Iphone 13
	Iphone 14	1000			Iphone 14	1000
	Iphone 14	1000			Iphone 14

Is anyone able to help?

KR,

B

[Jihwan_Kim]

Hi,

I assume your table contains one more column that indicates the difference between the same product, for instance, date column or index column.

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

It is for creating a new table.

Data table

Expected result table

Expected result table = 
SUMMARIZE (
    ADDCOLUMNS (
        ADDCOLUMNS (
            SUMMARIZE ( Data, Data[Index], Data[Product], Data[Price for the month] ),
            "@indexmin", MINX ( FILTER ( Data, Data[Product] = EARLIER ( Data[Product] ) ), Data[Index] )
        ),
        "@Price for the month", IF ( Data[Index] = [@indexmin], Data[Price for the month] )
    ),
    Data[Product],
    [@Price for the month]
)