Forum Discussion
Need Help Writing a Dated Difference Formula
I have a txt file brought into PowerBI via a sharepoint folder, and its a list of transmitted documents and the dates in which each transmission happened. I don't necessarily care about all of the c...
You can created calculated columns like these:
Earliest Date =
CALCULATE ( MIN ( Table[Sent Date] ), ALLEXCEPT ( Table, Table[Filename] ) )
Latest Date =
CALCULATE ( MAX ( Table[Sent Date] ), ALLEXCEPT ( Table, Table[Filename] ) )
And then create another column to get the difference.