Forum Discussion
PowerBI record date
Hi all im wondering if theres a way in powerbi to write a function that can record dates and log them below is an example i have where i have a date column that just generates todays date whenever the "install status" column reads "installed". the only problem is that with this method i can only generate todays date each time one of the install status's switches. which is why im trying to see if theres a record function or a way to log whatever value shows up in the install date column so that i can show a varity of dates and not just todays date
| install status | install date | record date? |
| Not installed | ||
| Installed | 8/15/2023 | |
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| Not installed | ||
| installed | 8/15/2023 |
DAX append may help:
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/If you find this insightful, please provide a Kudo and accept this as a solution.
1 Reply
- devesh_guptaImpactful Individual
DAX append may help:
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/If you find this insightful, please provide a Kudo and accept this as a solution.