Calculated Column with Offset function not working in Power BI service

[mschuurman]

I created a Calculated column in Power BI  with the following code

GeldigTot =
VAR datum =
    MINX (
        OFFSET (
            1,
            FctDienstverbandHist,
            ORDERBY ( FctDienstverbandHist[MutatieDatum] ),
            KEEP,
            PARTITIONBY ( FctDienstverbandHist[DienstverbandCode] )
        ),
        FctDienstverbandHist[MutatieDatum] - 1
    )
RETURN
    IF ( NOT ( ISBLANK ( datum ) ), datum, DATE ( 2999, 12, 31 ) )

then used the calculated column in several measures. in PBI Desktop, everything works fine, but when I Publish it to PBI service, I get the following error:

Couldn't load the data for this visual

The query referenced calculated column 'FctDienstverbandHist'[GeldigTot] which does not hold any data because there is an error in its expression.

Please try again later or contact support. If you contact support, please provide these details.

Activity ID: 6f8e9d3d-1c4e-4df9-8ff7-db74987d495f
Request ID: ad7602c1-27c2-18f0-6384-cc3a4d267e5b
Correlation ID: 3fd9a0f0-14a5-092a-8922-359c6398c3ca
Time: Thu Jan 19 2023 19:07:53 GMT+0100 (Central European Standard Time)
Service version: 13.0.19679.83
Client version: 2212.2.11664-train
Cluster URI: https://wabi-west-europe-e-primary-redirect.analysis.windows.net/

[Anonymous]

Hi @mschuurman ,

During my investigating, we found a answer like below:

As mentioned in the limitations section in our documentation on this feature, this is currently not supported in the Service, so I'd caution against doing this in Desktop unless you are not going to publish your model to the Service. 

Best regards.
Community Support Team_ Caitlyn

[mschuurman]

Hi @Anonymous,

the link you posted in your response mentioned DirectQuery specificly. But I'm using ImportMode.

on the documentation page of the OFFSET function(https://learn.microsoft.com/en-us/dax/offset-function-dax) there are no comments on limitation in the Power BI service.

Best Regards,

Michael Schuurman