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.
This works great but also filters out any ticket that could be blank or pending or in work as such but we need to keep those tickets.
The file has several years worth of data and were trying to shrink it down.
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0))
Solved! Go to Solution.
@jimb1955 , Either create a column or try script like
[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) and [Status] <> "Closed"
[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or [Status] = "Open"
[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or [Date Closed UTC] = null
Thank you that worked great.
@jimb1955 , Either create a column or try script like
[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) and [Status] <> "Closed"
[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or [Status] = "Open"
[Date Closed UTC] > #datetime(2020, 6, 30, 0, 0, 0) or [Date Closed UTC] = null
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |