Forum Discussion
Anonymous
6 years agoNot applicable
NEED help, measure table creation
Hi people, I am in a pickle. At the moment I have standard table with calculated columns, "Resource in use (seconds)", "Total per resource" and "Utilization". As this table is a calcu...
v-yuta-msft
Community Support
6 years agoAnonymous ,
You may create a measure using dax below:
Capacity (sec) = DATEDIFF ( Resource[Start of use], Resource[Todays date], DAY )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
6 years agoNot applicable
Hi,
Thanks for the reply. I have already tried that solution and it did not give the desired solution.
My question was and still is, can I somehow create a measure and assign it three different values as inputs.