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...
Need Help
  • 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.

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

It's alive! 😄 

 

fully working now.  thanks so much for the assist.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hey Gumberculeez ,

 

you are welcome!