Forum Discussion

Sairao's avatar
Sairao
Frequent Visitor
6 years ago

Power bi desktop

Which dax function is used to restore original data with no transformations, measures & calculated columns except all functions
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

    • Sairao's avatar
      Sairao
      Frequent Visitor
      6 years ago
      For example I am working on the project, if someone disturbed or modified my data using dax functions, measures and calculated columns and also performed transformations on the data, how could I get back my original data using only single dax function
      Note: 1) Without closing and opening the power bi
      2) Without using "All" dax functions
      3) Without using query editor
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Sairao ,

     

    Dax functions, measures and calculated columns will not change the raw data, you can just delete it to undo the change.

    But if they change the power query, added step can be deleted to restore, and if they changed steps, you might need to modify the query to restore.

    Sorry for that there is not a DAX function can fix it.

     

    If you want to restore the change of visual or field applied in the report, You can try the Undo button in the upper left corner.

     

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.