Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Nevermind, this one should do:
SELECT [test]
from table.report
where convert(varchar, getdate(), 112) between date_start and date_end
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.