Forum Discussion

tomq04's avatar
tomq04
Helper I
9 years ago
Solved

Adding/Subtracting Hours from a date from Redshift Source using DAX

I'm currently trying to subtract 8 hours from a date/time stamp hosted in Redshift.  This function works just fine when conntected to a SQL Server source (using literally the same table) but it is only subtracting 29 seconds from the Redshift table.

 

I'm currently using a last ditch effort  DAX formula (Adjusted_Posted = list_financial_events[posted_date] -(8/24)), but we have tried several iteration in both Power Query and DAX to perform this function, with the result always being -29 seconds.

 

Thanks,

 

Tom

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi tomq04,

    Could you please use import mode to upload some records of data from Redshift to Power BI Desktop, then check if the issue persists?

    Thanks,
    Lydia Zhang

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi tomq04，

    Could you please post sample data of your table? In Query Editor of Power BI Desktop, you can add a custom column using the following formula. You can view the example in the screenshot below.

    [DateColumn]-#duration(0,8,0,0)

     

    Thanks,
    Lydia Zhang

    • tomq04's avatar
      tomq04
      Helper I
      9 years ago

      That did work, but it knocks us out of direct query mode.  I'll see if that is acceptable for our use case.

      • tomq04's avatar
        tomq04
        Helper I
        9 years ago

        I mispoke earlier, I had been connected to our SQL server data warehouse.  Attached is what is happening when connected to our Redshift Server.  redshift error