Forum Discussion
Solved
If condition with time duration
Hello, Please help to have this duration negative calculation in the query, in Excel I used to use the function below. The first is excluded from the sum of durations and automatically gets that -1...
table is the table name, you can change it to your table name and have a try.
Yes almost but not [Name] it's [Correction]
** Column = if('Table'[Name]=0,'Table'[Capacity [%]]]*'Table'[Duration [h]]]/100)*24 **
When I test it the app can not finde 'Table' see screenshot below
Many thanks