Multi query sum showing only today's date

[Gumberculeez]

Hey All;

Curious how I can do this?  I have the multi query sum down...

Mileage plus Mileage =

SUM('SCInvLabor'[Mileage]) + SUM('SCOpenLabor'[Mileage])  

however, I'd like to add a filter to show just the above just for today.

an assist would be fantastic! 🙂

[mwegener]

Hi @Gumberculeez ,

create a date table

Date = 
ADDCOLUMNS (
        CALENDARAUTO( ); 
    "Year"; YEAR ( [Date] );
    "Month Name"; FORMAT ( [Date]; "mmmm" );
    "Month Number"; MONTH ( [Date] );
    "Weekday"; FORMAT ( [Date]; "dddd" );
    "Weekday number"; WEEKDAY( [Date] );
    "Quarter"; "Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1;
    "Day of Month"; Day([Date])
)

add the relationship to the date table

Mileage plus Mileage =
CALCULATE(
SUM('SCInvLabor'[Mileage]) + SUM('SCOpenLabor'[Mileage]);  
'Date'[Date] = TODAY())

If I answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Gumberculeez]

hmm... thanks for the assist here, 

Actually getting a syntax error with that : /

[mwegener]

Hi @Gumberculeez ,

replace ; with , 

[Gumberculeez]

Thanks... that worked...

however, getting the same syntax error with the relationship...  changed to a "," with no results:

[mwegener]

Hi @Gumberculeez 

the CALCULATE is missing...

Mileage plus Mileage =
CALCULATE(
SUM('SCInvLabor'[Mileage]) + SUM('SCOpenLabor'[Mileage]);  
'Date'[Date] = TODAY())

If I answer you question, please mark my post as solution, this will also help others.

Please give Kudos for support.