Use Duration.Days and LocalNow() for # Days until/since a Date in Power BI using Power Query Editor

Описание: Use Duration.Days and LocalNow() for counting and displaying the number of Days until (or since) the latest completed Assessment Date in Power BI. Uses the following Power Query Editor
FORMULA: Duration.Days([Next Assessment Date]-(DateTime.Date(DateTime.LocalNow())))
LIST of VIDEOs in this PLAYLIST:
1. Use a Rule to Conditionally Format a Date Column in Power BI (3m10s) -    • Use a Rule to Conditionally Format a Date ...  

2. Import Salesforce Object into Power BI with Power Query Editor (3m39s) -    • Import Salesforce Object into Power BI wit...  

3. Use Date.AddMonths function to create a new Column of future Dates in Power BI - Power Query Editor (3m00s) -    • Use Date.AddMonths function to create a ne...  

4. Use Duration.Days and LocalNow() for Days until/since a Date in Power BI using Power Query Editor (4m22s) -    • Use Duration.Days and LocalNow() for # Day...  

5. Final Prep steps for Power BI Conditional Format by Rule for Date column (5m01s) -    • Final  Prep steps for Power BI Conditional...  

6. [return to first step] 1. Use a Rule to Conditionally Format a Date Column in Power BI (3m10s) -    • Use a Rule to Conditionally Format a Date ...