Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey All;
Curious how I can do this? I have the multi query sum down...
Solved! Go to Solution.
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.
You could just adjust the formula as below:
Mileage plus Mileage =
CALCULATE ( SUM ( 'SCInvLabor'[Mileage] ), 'SCInvLabor'[Date] = TODAY () )
+ CALCULATE ( SUM ( 'SCOpenLabor'[Mileage] ), 'SCOpenLabor'[Date] = TODAY () )
and you could also use mwegener's way that add a date table and then create the relatinship with fact table and just filter as 'Date'[Date] = TODAY()
Regards,
Lin
interesting.... I'm not getting any errors now with both solutions... however the formula itself is not working it seems...
It's "refresfing" however, it just maintains (BLANK) even though displaying each of those seperately provide numbers.
Could it have something to do with this being direct query information?
for sure... and thanks for the continued assist. this is new territory for me 🙂
Looks good.
Are new data in the table?
Have filters been set?
there is ya... and filters are on.
This pic shows the 2 queries with the measure we are working toward on top...
Could this be the issue guys? Seems the dispatchtime is pulling over a time stamp as well.... is it messing with the Today value?
I'm doing a direct query from the SQL database in PowerBI.
Hi @Gumberculeez ,
with SQL you can use a CASE, to convert a datetime to date
CAST(DispatchDate as Date) AS DispatchDate
with Power Query you can change the datatype from datetime to date
If I answer you question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Just to confirm, I'm required to do this in SQL Studio or PowerBI?
I'm direct query'ing data directly from our business system's SQL database. So I not altering that.... lol
at Power BI.
Could you share a screenshot from your query?
If I answer you question, please mark my post as solution, this will also help others.
Please give Kudos for support.
this is the current statement I use...
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.
It's alive! 😄
fully working now. thanks so much for the assist.
Hi @Gumberculeez ,
maybe you could post more information about your model.
Do you use a date table?
If I answer you question, please mark my post as solution, this will also help others.
Please give Kudos for support.
I'm using an SQL direct query.
Each query I'm bringing in has a date field. However, either will impact the measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |