Forum Discussion

PaulWo's avatar
PaulWo
Frequent Visitor
7 years ago
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...
Need Help
  • PaulWo's avatar
    PaulWo
    6 years ago

    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.

PaulWo's avatar
PaulWo
Frequent Visitor
6 years ago

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.

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    By putting it into the Query Editor, it will always be refreshed every time that the entire dataset is refreshed.