Forum Discussion
HB2104
Helper I
Helper IIf than in PBI
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 |
HB2104 In DAX:
Column = IF( LEFT( [Schedule], 3 ) = "QTR", [Quarterly Count], [Month Count] )
1 Reply
- Greg_Deckler
Community Champion
HB2104 In DAX:
Column = IF( LEFT( [Schedule], 3 ) = "QTR", [Quarterly Count], [Month Count] )