Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need a custom date filter that includes anything from the past 60 days. I don't see in "Filtered Columns" that this is an option. I have put a custom SQL statement into the Advanced Editor, but I am getting timeout errors when I apply changes or refresh the data.
So, is there a way to edit the statement below to reflect > 60 days ago instead of > a specific date?
[destination_earliest_arrival] >= #datetime(2018, 11, 1, 0, 0, 0)
Thanks, @Anonymous. I will give that a shot. I did not know the proper syntax to make the change. I tried something similar to the SQL code, but that was not correct.
Hi @schwinnen,
For your scenario, you could consider to use query parameter to get the data from past 60 days.
With the Query Parameters, we can define one or multiple parameters to be used in the queries, Data Model and report layers in Power BI Desktop.
For example, to pass the date parameters in PQ Query, you can create a new Query Parameter of Date, then use this date parameter to filter your corresponding date column in the Query. For more details about POWER BI DESKTOP QUERY PARAMETERS, you can refer to this article.
"Startdate" and "Enddate" are two parameters.
let Source = Sql.Databases(""), AdventureWorksDW2012 = Source{[Name="AdventureWorksDW2012"]}[Data], dbo_DimDate = AdventureWorksDW2012{[Schema="dbo",Item="DimDate"]}[Data], #"Filtered Rows" = Table.SelectRows(dbo_DimDate, each [FullDateAlternateKey] >=Startdate and each [FullDateAlternateKey] <= Enddate ) in #"Filtered Rows"
In addition, if it is convenient, could you share some data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |