Forum Discussion

vsorensen's avatar
vsorensen
Frequent Visitor
1 year ago
Solved

Using measure to compare two columns in a matrix

As the title suggests, I have two columns in a matrix that I need to compare. Both are date columns and I am trying to display the difference between the two. The issue I'm having, is when I try to d...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    vsorensen Try:

    Start Variance = 
  SWITCH( TRUE(),
    [Start] = BLANK(), BLANK(),
    [Start] = [BL Start], 0, 
    NETWORKDAYS([Start], [BL Start])
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
1 year ago

vsorensen Try:

Start Variance = 
  SWITCH( TRUE(),
    [Start] = BLANK(), BLANK(),
    [Start] = [BL Start], 0, 
    NETWORKDAYS([Start], [BL Start])
  )