Changing a display date

[Maesknoll]

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?

[muhammad_786_1 · Accepted solution]

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 · Accepted solution]

Perfect, thank you

[muhammad_786_1 · Accepted solution]

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