topic Re: Measure on dataset based on excel file in DAX Commands and Tips

Measure on dataset based on excel file

Anonymous — Fri, 01 Sep 2023 14:22:38 GMT

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?

christinepayton — Fri, 01 Sep 2023 15:08:47 GMT

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 — Fri, 01 Sep 2023 15:19:02 GMT

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.

Anonymous — Tue, 12 Sep 2023 12:28:48 GMT

Thank you all for reply. Everyhing is working fine now.