Forum Discussion

Fab117's avatar
Fab117
Helper IV
3 years ago
Solved

Calculate date difference vs today date

Hello,   I'm newbie with Power BI. I'm quite familiar with VBA, but not at all with Dax => PowerQuery requests.   I started building my first Power BI report based on several data base fields, b...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Fab117 ,

     

    In Power Query:

    New custom columns:

     

    Variance =
Number.From(Date.From([TargetedDueDate])) - Number.From(Date.From(DateTime.LocalNow()))

// and

ProgressStatus =
if [Progress] = 100 then "Completed"
else if [Variance] > 20 then "On time"
else if [Variance] >= 0 and [Variance] <= 20 then "Due soon"
else if [Variance] < 0 then "Overdue"
else // your escape value e.g. null, "Unknown" etc.

     

     

    Pete

Fab117's avatar
Fab117
Helper IV
3 years ago

NB: I found the way to issue a Query => for Nate proposal, I also tried:

In Power Query: Tab "Home", Icon "New Source", "More", "Other" and "Blank Query"

 

But I can't see the new column which should have been created

Same when tried to mention in which data base field [TargetedDueDate] could be found: