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 my displayed data in the visual to show -1 day from the date in the table?

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

2 Replies

  • 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