Forum Discussion

bjpowell93's avatar
bjpowell93
Frequent Visitor
4 years ago
Solved

Creating a Non-Volatile TODAY() function in New Column

Hi all,   I have a dataset that will be refereshed regularly and contains c.450,000 rows of individual products. In each row are a series of pass/fail criteria in different columns. Once all of the...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi bjpowell93 ,

     

    No, power bi is sent query to data source to get data then calculate. If you refresh, it will refresh the whole data, so the calculation result won't be saved. It means you can not keep the date created by today()

     

    You can try add the date in original data source or maybe you can try python script in power bi query, run python script to save the date then power bi get data from the python script result.

    Run Python Scripts in Power BI Desktop - Power BI | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi bjpowell93 ,

     

    Fill the date with the formula in the power query.

    Add custom column to fill which row has no date.

     

    Then the resulting result is rewritten to the file. I use the .csv file format here.

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi bjpowell93 ,

 

No, power bi is sent query to data source to get data then calculate. If you refresh, it will refresh the whole data, so the calculation result won't be saved. It means you can not keep the date created by today()

 

You can try add the date in original data source or maybe you can try python script in power bi query, run python script to save the date then power bi get data from the python script result.

Run Python Scripts in Power BI Desktop - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

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

  • bjpowell93's avatar
    bjpowell93
    Frequent Visitor
    4 years ago

    Hi v-chenwuz-msft,

     

    Thanks for these ideas - do you know what the Python script would look like?

     

    Using Python isn't something I'vr done before. 

     

    Thanks!

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi bjpowell93 ,

       

      Fill the date with the formula in the power query.

      Add custom column to fill which row has no date.

       

      Then the resulting result is rewritten to the file. I use the .csv file format here.

       

      Pbix in the end you can refer.

      Best Regards

      Community Support Team _ chenwu zhu