Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
diskovered
Helper III
Helper III

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 week in this date format. 

1 REPLY 1
diskovered
Helper III
Helper III

Nevermind, this one should do:

 

SELECT [test]

from table.report

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.