Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Calculate dates difference between different rows AND columns

Hello all, I need jedis' mind. Consider I have following data: Task_ID Date_Created Date_Completed 1 08/08/18 12:05:02 08/08/18 12:06:08 2 07/08/18 1...

Need Help

Tutorial Requests

TomMartens
8 years ago
Hey,

here you will find a little tutorial on how to create Calculated Columns in Power BI
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

This describes how to use variable in DAX
https://powerbi.tips/2017/05/using-variables-within-dax/

This describes the DAX function DATEDIFF
https://msdn.microsoft.com/en-us/query-bi/dax/datediff-function-dax

Regards,
Tom

TomMartens

Super User

8 years ago

Hey,

here you will find a little tutorial on how to create Calculated Columns in Power BI

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

This describes how to use variable in DAX
https://powerbi.tips/2017/05/using-variables-within-dax/

This describes the DAX function DATEDIFF

https://msdn.microsoft.com/en-us/query-bi/dax/datediff-function-dax

Regards,

Tom

Anonymous

Not applicable

8 years ago

Thank you, I will investigate that!

Forum Discussion

Calculate dates difference between different rows AND columns

Related content

Dynamic Calculation Different Period

Different schema into different destination

Different Calculations

1. How to add two different calculated columns of two different table

How to add two different calculated columns of two different table