@ankitpatiraThanks for the reply. Unfortunately, I don't see the "Quick Calc" option you have in your picture. Those menu options seem to vary depending on the underlying data type. I'm using the Number type for the ID field, and here is what I see:
If I select a Text field, here is what I see:
What field type were you using to get the "Quick Calc" field?
@v-micsh-msft Thanks for the suggestion! I'm not using Power BI Desktop, but I believe I can accomplish adding the Measure directly in the Excel file. I'll give that a try and will post back if I run into any issues.
Any ideas on if or how this can be accomplished within the Power BI service? I would rather be able to do it from the Power BI interface than go messing with the Excel file if I can avoid it.