Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone,
So i'm getting my data from sql server, i have column date which contains dates from 1 january 2022 to 31 december 2022 i'm looking forward to do a dynamic filter so i can get only the dates that are superior to the current date.
How can i do it
thank you
Solved! Go to Solution.
@Mannai , Go and add any custom date filter >=
Then go and replace that date with DateTime.Date(DateTime.LocalNow())
or
DateTime.Date(DateTime.FixedLocalNow())
You have to open advance editor and do that. Option on right click of table/Query
@Mannai , Go and add any custom date filter >=
Then go and replace that date with DateTime.Date(DateTime.LocalNow())
or
DateTime.Date(DateTime.FixedLocalNow())
You have to open advance editor and do that. Option on right click of table/Query
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
118 | |
101 | |
76 | |
68 |