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

ase — Sun, 30 Apr 2023 23:10:00 GMT

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,

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

Jihwan_Kim — Mon, 01 May 2023 03:25:25 GMT

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] )

topic Re: DAX function that fills a column with one of my current values and leaves the rest of rows blank in DAX Commands and Tips

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

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