Forum Discussion
Refreshing report with calculated column from shared point fail
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?
1 Reply
Hi mgraffeoiannone ,
Please delete the dataset in Power bi service and republish the report to service to check again.
