Add Project Task (project for the web) priority to Power BI report

[CaljanJST]

Dear all -

we are working with project for the web. I am currently trying to set up a task overview and a my work overview. 

For us it is manadatory to see the priority by task (msdyn_priority). When I try to add the column, it is not even listed under project task (even if the column is available):

Any thoughts?

Kind regards,

Julia

[v-rongtiep-msft · Accepted solution]

Hi @CaljanJST ,

What is the priority? A measure or a column?

If it is a column, it can be quoted directly.

If it is a measure, we cannot   quote it directly.

Please refer to the following documents about the differences between the measure and column.

Power BI - Calculated Columns Vs. Measures what’s the difference? (niichiconsulting.com)

Solved: column vs measure - Microsoft Power BI Community

• Calculated columns (and tables) are:

  - Evaluated for each row in your table, immediately after you hit 'Enter' to complete the formula

  - Saved back into the model so take up space

  Calculated Measures are:

  - Evaluated when you use it in a visual, when the visual is rendered

  - Not saved anywhere (well, actually there's a cache in the report layer but it's not part of the file when you hit Save)

  Generally, measures are more useful, but the trade-offs are the performance hit (report runtime vs. pre-processed), storage space, and the type of expressions you can use. For example calculated columns are often used when you want to filter on the result rather than just as a calculated result.

How to Get Your Question Answered Quickly 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.