Forum Discussion

data23f's avatar
data23f
Helper I
6 years ago
Solved

Find the date difference for a single column

Hi,   I have a Date field in a table.             My goal is to create a new column that calculates the date difference from the previous date in # of days. For example: • 1/17/20 an...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Icey's avatar
Icey
Community Support
6 years ago

Hi data23f ,

 

A calculated column can't change automatically, but a measure can. So, you need to create a measure, not a column. Please check whether Ashish_Mathur 's measure works.

 

 

Best Regards,

Icey

 

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