Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am very new to PowerBI and this forum but have managed to pull in a number of API datasets and using queries to modify the data. I was rather foolishly creating a query to filter each set of data but that means each time the date refreshes it does a refresh times the number of queries making it very slow. I had 4 queries, I now have one and have managed to use a combination of calculated columns and measures to get the same results from just 1 query. The problem I have is with the fourth part. I need to get a count of dates that are less than TODAY's DATE minus 3 days. I also need to filter and exclude the word "resolved" from another column. Below is some of the query code I was using and am now trying to replicate using columns and measures.
FilterDatesBefore = Date.AddDays(DateTime.Date(DateTime.LocalNow()), -3), //sets the date in the variable
#"Filtered Rows" = Table.SelectRows(#"Expanded pagedetails", each ([status] <> "Resolved")), //removes any rows with Resolved
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [updated_at] < FilterDatesBefore) //gets the remaining data
Hope someone can help as have been trawling Google for a while on this. TIA.
Solved! Go to Solution.
Apologies for this. I persevered and have managed to make this work. I had to learn a basic skill in using multiple filters which unlocked the solution for me. My measure code is below.
Can you supply some sample data for this? I am pretty sure this is possible, but M code is finicky enough that I won't give you somethign that I haven't tested. See links below on how to do it.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingApologies for this. I persevered and have managed to make this work. I had to learn a basic skill in using multiple filters which unlocked the solution for me. My measure code is below.