Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
hi,
I have 2 date columns
some of the values in 2nd column i.e. routing approval date are null
I subtracted column 2 - column 1
also I have 3 document types like below
for in approval when subtracted coulumn 2 - column 1 i got values
but for in commenting doc I'm not getting values as column 2 has null values for that commenting doc
Now I want the to subtract null values from column2 - column1 such that i get some output
eg - 0 -20 = 20
Screenshot of results im getting
1. values I get when sleected approval docs
2. no values shown for commenting docs
plz assist ne in this
then I want to sort the reult values as >10 and <10
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.