Forum Discussion

bence's avatar
bence
New Member
4 years ago

[Bug] Pipeline deployment messes up calculated dates

Hi everyone,

I am using PowerBI Service and Pipelines for a moment, but I never encountered a bug like that one.

Basically, I have a table with dates, and a custom calculated column giving me the current week that looks like that:

 

Filter Year+Week =
IF (
    'Table_Dates(onlyMonday)'[Year] = YEAR ( TODAY () )
        && 'Table_Dates(onlyMonday)'[ISO Week Number] = WEEKNUM ( TODAY (), 21 ),
    "Current",
    CONVERT (
        ( ( 'Table_Dates(onlyMonday)'[ISO Year] * 100 ) + 'Table_Dates(onlyMonday)'[ISO Week Number] ),
        STRING
    )
)

 

Everything works like intended in desktop and in my dev workspace once I publish it.
I  also inserted UTCNOW() for debugging pusposes.
Dev workspace

 

But once I deploy in Test (or Prod) workspace through the pipeline, I have my calculations that are off, even after refreshing all sources:
test

 

Does anyone have any idea why? I never had an issue similar and it looks like the pipeline somehow messes up my calculated columns.

 

Thanks

4 Replies

  • I have seen similar in the latest Power BI Desktop (August 2022 CFE1) where a date of "2022-01-01" would yield "December" when called with FORMAT([Date],"mmmm") .  Wonder if that is related.

    • bence's avatar
      bence
      New Member

      Hello,

      Not sure it is directly related, but there is something weird about the dates in the August version. I have trouble understanding how my dev and test datasets can compute different results with the same formula

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        Definitely. And QFE1 has not addressed these issues yet.

  • LeeBenjamin's avatar
    LeeBenjamin
    Icon for Microsoft Employee rankMicrosoft Employee

    Please open a ticket if this issue is still relevant, so we could investigate further.
    Thanks you,
    Lee