Measure function using if formula

[hidenseek9]

Hi Power BI Community,

I have a simple question regarding a measure.

In a data set, I have price and date.

What I would like to do is to convert the price to a different currency

and if the dates is in S1 (from Jan to Jun), use one rate and if the date is in S2 (July to Dec)

use another rate.

Any recommendation?

Dummy Data

I attached teh dummy data above.

Appreciate your support.

Many thanks,

H

[SivaMani · Accepted solution]

@hidenseek9,

Calculated Price = IF(MONTH('Dummy Data'[Date]) <= 6, 'Dummy Data'[Price] * 10, 'Dummy Data'[Price] * 20)

Is that what you're expecting?