Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a query I am running it selects data from 2 tables. I am trying to get get both tables to uese the same date range. The query below was modified to try to get both tables to return the last 7 days worth of data. The blue text is what I added.
WHERE (d.TimeDown >= DATEADD(day, - 7, GETDATE(), (Date >= DATEADD(day, -7, GETDATE()))"]), I get a syntax error near ">" which started when I added the second date statement. Can this be resolved, or am I writing this incorrectly? So far, my original table will pull the last 7 days as requested, but the second table delivers everything since 2005.
No, I am looking for the past 7 days. Today, I would be looking for June 7th thru June13th from both tables One uses the the 'TimeDown' field as the date, the other currently uses 'Date' Note: I could use TimeOpen in table 2, which would give me two date/time fields (if that is easier).
@Anonymous , are you writing a SQL in advance option
try like
WHERE (d.TimeDown >= DATEADD(day, - 7, GETDATE()) and (d.TimeDown <= DATEADD(day, 0, GETDATE())))
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
18 | |
15 |
User | Count |
---|---|
38 | |
20 | |
19 | |
16 | |
10 |