Forum Discussion
Gumberculeez
Helper II
6 years agoMulti 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...
- 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
Helper II
6 years agothis is the current statement I use...
mwegener
Most Valuable Professional
6 years agoHi 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.
- Gumberculeez6 years ago
Helper II
It's alive! 😄
fully working now. thanks so much for the assist.
- mwegener6 years ago
Most Valuable Professional