Forum Discussion
Maesknoll
2 years agoRegular Visitor
Changing a display date
Hi, I have some data that comes from email, this is transformed via a script, the date of my data is picked up from the email header, this is the day after the data is collected. How can I change m...
- 2 years ago
Hi Maesknoll
There are multiple ways to do this.
I assumed you have this kind of data:
You just need to go to the Modeling tab and add a new column using this DAX:
NewDate = 'EmailData'[OriginalDate] - 1
You'll get this output:
Please see, if this is what you want.
Best Regards,
Muhammad YousafIf this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.
- 1 year ago
Perfect, thank you
Maesknoll
1 year agoRegular Visitor
Perfect, thank you