Forum Discussion

JMSNYC's avatar
JMSNYC
Helper III
5 years ago
Solved

Sum Based on Conditional Values from Another Table Columns

Hi.   I cannot figure out how to sum column C from Table 1 based on the condition that column B values fit the interval (Column I and J)   Could anyone help me solve that problem? Everytime I...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    JMSNYC - Should be as a column:

     

    Actual Revenue = SUMX(FILTER(RELATEDTABLE('DAILY REVENUES'),[Date Rev.]>=[Tender Start Date] && [Date Rev.]<=[Tender End Date]),[Revenue])

     

    If that does not work please @ me

    I did confirm this in the attached PBIX file below sig. Table (23), Table (23a), Table (23b)

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

JMSNYC - Should be as a column:

 

Actual Revenue = SUMX(FILTER(RELATEDTABLE('DAILY REVENUES'),[Date Rev.]>=[Tender Start Date] && [Date Rev.]<=[Tender End Date]),[Revenue])

 

If that does not work please @ me

I did confirm this in the attached PBIX file below sig. Table (23), Table (23a), Table (23b)