Скачать или смотреть 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 ...