Forum Discussion

Maesknoll's avatar
Maesknoll
Regular Visitor
2 years ago
Solved

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...
Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    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 Yousaf

     

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

     

    LinkedIn

  • Maesknoll's avatar
    Maesknoll
    1 year ago

    Perfect, thank you

muhammad_786_1's avatar
muhammad_786_1
Solution Supplier
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 Yousaf

 

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

 

LinkedIn