How to convert numeric fields w/implicit measures that come from PowerBI in Pivot table using the Analyze in Excel function

Power BI
5

Hey Melissa,
I tried using the MDX Calculated measures table to create a measure for eg. [Actual Crop Revenue]*1 but it doesn’t give any values. I can drag the now new measure into the Values section but there is no data to show in that field.

36
Screen Shot 2019-11-27 at 10.20.36.png1311×669 26.3 KB
. In either case I don’t think this solution would work because it is not something we can offer to out customers a a solution. but thank you for suggesting this.