Forum Discussion
Measure on dataset based on excel file
Hello Everyone,
Any idea why i can't use any of the columns that are visible in the source, which is excel file stored on sharepoint?
You need to put a function in there, so start typing "SUM(" and then start typing "amount" and it should populate in the dropdown.
3 Replies
- christinepayton
Most Valuable Professional
You need to put a function in there, so start typing "SUM(" and then start typing "amount" and it should populate in the dropdown.
- ERD
Community Champion
Anonymous , this article will help you to understand the difference between measures and calculated columns: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/ and thus will answer your question.
