Forum Discussion

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
6 years ago

monday WHERE in PowerBI

SELECT [test] from table.report where 20200611 between date_start and date_end   Does anyone know how to do this....I need to make this 20200611 dynamic so it's always the current Monday of the w...
Need Help
Tutorial Requests
diskovered's avatar
diskovered
Icon for Helper III rankHelper III
6 years ago

Nevermind, this one should do:

 

SELECT [test]

from table.report

where convert(varchar, getdate(), 112)  between date_start and date_end