Forum Discussion
Add Project Task (project for the web) priority to Power BI report
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
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.-
1 Reply
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.-