Forum Discussion
Solved
Calculated Columns not updating on scheduled refresh
I have created the following calculated columns: Domestic = if('Shipping Requests'[InternationalShipment]="TRUE",0,1) International = if('Shipping Requests'[InternationalShipment]="TRUE",1,0) G...
The calculated columns I described at the start of this thread were created in PowerBI Desktop. I tried moving the creation of these calculated columns to the Power Query Editor. That change eliminated the problem. Not sure why but it worked.
Hi there,
I have exactly the same issue, the calculated field works fine in PWBI DSK but not in the PWBI service unless i edit the formula of the calculated filed and due the calculation is made using Today Date the day after the calculated value is again not corect. The calculated value is also not refreshed in the sparepoint list where i have the formula but that field looks correct calculated within Power Bi Desktop Report (sourced by the sharepoint list) . That i do not understand.