DAX Help

[Anonymous]

	From	To	Price (Measure)
Apple	1/12/2020	2/1/2021	$10
Orange	1/3/2021	21/4/2021	$15
Pine apple	1/6/2021	31/6/2021	$25

I have a product sold for $10 from the month Jan - March. I have a measure that calculates the selling price. I should repeat this 10 based on the product name. The measure here is simple but the actual measure i have is a MedianX which avoiding the duplication. But I would now want to see the price 10 both in the month of Dec 2020 and Jan 2021. 

Is there a value to replicate the measure based on a key for other months.

[v-zhangti]

Hi, @Anonymous 

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards

[v-zhangti]

Hi, @Anonymous 

Maybe you need to provide more information. For example, the original price of these products, and the output you expect. Or are you trying to output the result you want with the IF function?

Best Regards,

Community Support Team _Charlotte

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

[Anonymous]

@amitchandak  I would want to repeat the value not split it between in the month. 

[amitchandak]

@Anonymous 

check if the blog or attached file can help

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785