Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have 2 Tables-
I need to write a measure or create a column for if the Location is India and count less then 10 and postcode belong to the postcode list, then Count*50. ( to be notes that in actual data, the postcode lis is more than 500)
1) Order
Order No | Location | Count | Postcode |
abc | India | 5 | 1239 |
def | India | 10 | 3145 |
xyz | USA | 4 | 1254 |
2) Postcodes
POstcode | Location |
1235 | India |
1236 | India |
1237 |
India |
1238 | India |
1239 | India |
1210 | USA |
1214 | USA |
1243 | USA |
1254 | USA |
Solved! Go to Solution.
Hi
Please try the following DAX to create a new column.
Column = IF(
'Order'[Count]<10 && 'Order'[Location] = "India" && 'Order'[Postcode] in VALUES(PostCode[Postcode]),
'Order'[Count]*50,
'Order'[Count]
)
Hi
Please try the following DAX to create a new column.
Column = IF(
'Order'[Count]<10 && 'Order'[Location] = "India" && 'Order'[Postcode] in VALUES(PostCode[Postcode]),
'Order'[Count]*50,
'Order'[Count]
)
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |