Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed: Sum values based on date checking, two related tables.

I have two tables, joined on location. I need to determine what the daily budget hours from the LocationBudget table based on the location and date in the LocationCalendar table.   What I'm trying ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Here is a column expression that should get your desired result.

     

    Daily Hours =
    VAR thisdate = LocationCalendar[Date]
    RETURN
        CALCULATE (
            MIN ( LocationBudget[BudgetHours] ),
            LocationBudget[BudgetStart] <= thisdate,
            LocationBudget[BudgetEnd] >= thisdate
        )

     

    Regards,

    Pat

     

     

     

vpanchu's avatar
vpanchu
Helper I
5 years ago

Anonymous Sorry i am kind of finding it difficult to understand , Can you show me how should your output table look like so that i can try the logic if possible