If than in PBI

[HB2104]

Hi All -

Looking to create a new column below based on the schedule name it will take another columns values. So below example: anything in column schedule that starts with QTR will take Quarterly Count column values and anything in schedule called MTH will take Month Count values. Thanks! 

Schedule	Month Count	Quarterly Count	New Column
QTRREC18	2	4	4
MTHREC18	6	11	6
QTRREC18	5	8	8
QTRREC18	6	12	12
MTHREC18	23	3	23
MTHREC18	1	2	1

[Greg_Deckler · Accepted solution]

@HB2104 In DAX:

Column = IF( LEFT( [Schedule], 3 ) = "QTR", [Quarterly Count], [Month Count] )