Guest User

Untitled

a guest
Jun 16th, 2019
68
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Example:
  2.  
  3. **Cross table** **Item table**
  4. Bulk PKG Item Value
  5. A D A 2
  6. A E B 1
  7. B F C 4
  8. C G D 5
  9. E 8
  10. F 3
  11. G 1
  12.  
  13. Item Value Bulk PKG
  14. A 2
  15. B 1
  16. C 4
  17. D 5 A D
  18. E 8 A E
  19. F 3 B F
  20. G 1 C G
  21.  
  22. Item Value Bulk PKG NEW COLUMN
  23. A 2 5
  24. B 1 3
  25. C 4 1
  26. D 5 A D 5.75
  27. E 8 A E 9.2
  28. F 3 B F 3.45
  29. G 1 C G 1.15
  30.  
  31. New Column = if [Bulk] = null then [Value] else 1.15 * [Value]
  32.  
  33. New Column = IF( ISBLANK( Table1[Bulk] ), Table1[Value], 1.15 * Table1[Value] )
RAW Paste Data