Conditional Formatting on Calculated Date

Hello,

I am trying to highlight certifications that will expire in the next 30 days.  In my data I have an expiration date on the certification.  Once I got the data in I couldn't find a way to dynamically use todays date to find certifications expiring in the next 30 days, so I created a column in the "Power Query Editor" to calculate the days remaining.  The formula for that is below:

[Expiration Date]-DateTime.LocalNow()

However, this would not work in the Reports area.  The data comes back as something like 403.10:14:09.9422851 so it makes sense that PowerBI can't see this as a number.  I tried several variants to get just the days portion of the result, but I didn't find any formula options to get that for me.  Finally I decided to use the Split Column step to parse out the days into a separate column.  Now I can see the days remaining, but conditional formatting still will not work.

In the conditional formatting screen I see "Count of DaysRemaining.1" in the "Based on field" and "Count" in the "Summarization".  If I change the Format by to Field value then the screen blanks out and I have no color options or filter options.

So my questions are:

1.  How am I supposed to use conditional formatting with a date field and why don't I see the background color option on "Field value"?

2.  How am I supposed to parse the days out for the RemainingDays on certifications?  I assume my method of parsing is causing the problems, but I haven't found the right formula to use in the "Power Query Editor"

Thanks,

Eric