DAX Measures - data into columns based on DATES

[Annemie19]

Hi There, I have the data as shown below. I need to write a measure in PowerBI that will look at the REPORT FROM date. Then it needs to put the AMOUNT in the correct columns according to the REDEMPTION DATE. Thus, if the REDEMPTION DATE falls within the 1 Month, 1-3 Month, etc. bracket it will put the AMOUNT into that column as shown below. In Excel I used If statements, I'm just not sure how to do it in PowerBI.

[amitchandak · Accepted solution]

@Annemie19 , Create measures like

1 month =
var _max = maxx(allselected(Date),date[Date])
switch( true(),
datediff(max(Table[redemption Date]),_max,Month) <=1, max(Table[Amount]), blank())

1 -3 month =
var _max = maxx(allselected(Date),date[Date])
var _dif =datediff(max(Table[redemption Date]),_max,Month)
switch( true(),
_dif >1 && _dif <=3, max(Table[Amount]), blank())