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.
ryan_mayu
Super User
Super Userwhich columns are the column M and column N?
Hello,
Column N is [[ Duration [h] ]], Column M is [[ Capacity [%] ]].
Many Thanks
- ryan_mayu
is this what you want?
Column = if('Table'[Name]=0,'Table'[Capacity [%]]]*'Table'[Duration [h]]]/100)*24Yes 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 belowMany thanks
- ryan_mayu
table is the table name, you can change it to your table name and have a try.