Forum Discussion

mamoshareef's avatar
mamoshareef
Frequent Visitor
7 years ago
Solved

Calculation the sum in between two dates in two different tables

Hi All I have two tables and there is no relationship between them and I need to calculate the sum of one column in the second table between two specific dates in the first table. Please see the tw...
Need Help
  • mamoshareef's avatar
    mamoshareef
    7 years ago

    thanks a lot, I am editing the first solution to add a new column 

    Spoiler
    Total Fuel Add = 
    CALCULATE(SUM('Table 02'[Fuel Consumption]), FILTER(ALL('Table 02'), 'Table 02'[Work date] >= 'Table 01'[Date Last Stock Date] && 'Table 02'[Work date] <= 'Table 01'Stock take date && 'Table 02'[Water Station]='Table 01'[Water Station] )))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Share the link from where i can download your PBI file.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    I need the link from where i can download the PBI file.  In that file, clearly indicate the source and destination tables.

    • mamoshareef's avatar
      mamoshareef
      Frequent Visitor
      7 years ago

      thanks a lot, I am editing the first solution to add a new column 

      Spoiler
      Total Fuel Add = 
      CALCULATE(SUM('Table 02'[Fuel Consumption]), FILTER(ALL('Table 02'), 'Table 02'[Work date] >= 'Table 01'[Date Last Stock Date] && 'Table 02'[Work date] <= 'Table 01'Stock take date && 'Table 02'[Water Station]='Table 01'[Water Station] )))