Forum Discussion

Gumberculeez's avatar
Gumberculeez
Icon for Helper II rankHelper II
6 years ago
Solved

Multi query sum showing only today's date

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 fil...
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Gumberculeez ,

     

    than try this.

     

     

    SELECT
    *,
    CAST(DispatchDate as Date) AS DispatchDate_New
    FROM _custom_eviews.RTPowerBI (NOLOCK)

     

     

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

    Please give Kudos for support.