Forum Discussion

powerbiwork's avatar
powerbiwork
Icon for Helper I rankHelper I
5 years ago
Solved

Custom Column Query

Hi,  I am having issues for the following. Basically Im trying to pull a live currency rate but the currency is only pulled to todays date. In close I have future dates. I want to have a custom colu...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi powerbiwork ,

     

    You can try to create your custom column as

    if [Date]<=Date.From( DateTime.LocalNow())
then [Date] else Date.From( DateTime.LocalNow())

     

     

    Creating a calculated column is easier.

    Column = IF([Date]<=TODAY(),[Date],TODAY())

     

     

    You can check more details from here.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

lkalawski's avatar
lkalawski
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi powerbiwork ,

I noticed that you forget to add brackets before "else". Please try to add it. 

 

Proud to be a Super User.
If I helped, please accept the solution and give kudos! 
Linkedin

 

 
  • powerbiwork's avatar
    powerbiwork
    Icon for Helper I rankHelper I
    5 years ago

    Ah, got it thank you. But now I seem to have another error 😞 

     

    • lkalawski's avatar
      lkalawski
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

      powerbiwork 

      Before you add custom column, please check the format of CloseDate - should be "Date".

       

      Proud to be a Super User.
      If I helped, please accept the solution and give kudos! 
      Linkedin

       

      • powerbiwork's avatar
        powerbiwork
        Icon for Helper I rankHelper I
        5 years ago

        I've checked that it is date