Refreshing report with calculated column from shared point fail

[mgraffeoiannone]

Hi everyone,

I have an issue, I created a report from a file in shared point, and when I add the calculated column "Report Order = IF('SCDP - List Information'[CreatedDate]=[SCDP Max Col],"Latest Report", 'SCDP - List Information'[Title])" and "

SCDP Max Col = CALCULATE(MAX('SCDP - List Information'[CreatedDate]),FILTER('SCDP - List Information','SCDP - List Information'[Client Name Ref]="Capgemini US"))"

When I refresh it in the Desktop version it works.

When I publish it and refresh it on Power BI it fail and the error sais: The query referenced column 'SCDP - List Information'[Report Order] which depends on another column, relationship or measure that is not in a valid state.

Additional information: ".

Have someone  had similar issues?

[v-frfei-msft]

Hi @mgraffeoiannone ,

Please delete the dataset in Power bi service and republish the report to service to check again.