Forum Discussion

VFXPro's avatar
VFXPro
Icon for Advocate II rankAdvocate II
7 years ago
Solved

Simple calculated Date field using IF is not working...

 I'm simply trying to get a date value calculated using a column depending on a condition, but it doesnt' work, what I am missing?   Calculated Due Date:  If the contract is digital then use the (e...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    7 years ago

    Hi VFXPro

     

    If you are using the Power Query Editor, then you can add a custom column using this formula.  For something like this it doesn't really matter if you create it in M (Power Query) or DAX (Power BI Desktop)

     

    if [Format] = "Digital" 
then Date.AddDays([ReceivedDate],7) 
else Date.AddDays([EndDate],7)

     

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi VFXPro

 

If you are using the Power Query Editor, then you can add a custom column using this formula.  For something like this it doesn't really matter if you create it in M (Power Query) or DAX (Power BI Desktop)

 

if [Format] = "Digital" 
then Date.AddDays([ReceivedDate],7) 
else Date.AddDays([EndDate],7)

 

 

VFXPro's avatar
VFXPro
Icon for Advocate II rankAdvocate II
7 years ago

Thanks Phil_Seamark

This is very valuable guidance...  Thank you very much for your kindness and sharing your knowledge.