Forum Discussion
Get name based on ID from Power BI dataset Excel - - Cubememberproperty?
Dear all
I have a question about using the data set from Power BI in excel.
I use the cubemember formula with a reference to a cell. eg.: =CUBEMEMBER("Budget 2023 Report";"[Product Data].[Material ID].&["&D2&"]"). This works fine.
However, based on this Material ID, I would like to extract as well the Material Description that is in the same table ([Product Data].[Material Description]). I search on the internet and thought Cubememberproperty might work. But I get #N/A.
Does anyone know if this is possible and how?
Thanks a lot for your help!
you can create a measure to get the item description according to the item code. say, new measure=max('Product Data'[Material Description])
then use CUBEVALUE to get it
=CUBEVALUE("Budget 2023 Report";"[Product Data].[Material ID].&["&D2&"]","[Measures].[New Measure]")
2 Replies
- wdx223_Daniel
Community Champion
you can create a measure to get the item description according to the item code. say, new measure=max('Product Data'[Material Description])
then use CUBEVALUE to get it
=CUBEVALUE("Budget 2023 Report";"[Product Data].[Material ID].&["&D2&"]","[Measures].[New Measure]")
Thanks a lot for your reply. I was hoping to have a more "simple" solution (wo additional measures). But at least we can work with this.
