Forum Discussion
Analyze in Excel - Error Message
Hello PBI Community
I'm getting an error message while trying to create a pivot table in Analze in Excel.
I was able to put business unit name in rows, but received the following error message when trying to put reveneue amount in value.
This is a simple pivot table, nothing complicated.
Much appreciate your help!
Thank you
You can't drag Power BI implicit measures as values in an Excel pivot table, you need to add the equivalent explicit DAX measure in your source data model.
2 Replies
You can't drag Power BI implicit measures as values in an Excel pivot table, you need to add the equivalent explicit DAX measure in your source data model.