Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello Folks,
I am new to powerbi and require your expertise to help me with a problem.
I am filtering out some data by defining some parameter.
#"Filtered by date range" = Table.SelectRows(#"Change to datetime", each [WRITTEN_DATE] >= RangeStart and [WRITTEN_DATE] <= RangeEnd)
but i am also missing the values with null value in written_date field. How can i manipulate this code to get those rows in which written_date is null.
Thanks!
Solved! Go to Solution.
Hi @Pravin_rajput,
#"Filtered by date range" = Table.SelectRows(#"Change to datetime", each ([WRITTEN_DATE] >= RangeStart and [WRITTEN_DATE] <= RangeEnd) or [WRITTEN_DATE] = null)
Hi @Pravin_rajput,
#"Filtered by date range" = Table.SelectRows(#"Change to datetime", each ([WRITTEN_DATE] >= RangeStart and [WRITTEN_DATE] <= RangeEnd) or [WRITTEN_DATE] = null)
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.