RonaldLieuw
New member
- Joined
- Sep 5, 2019
- Messages
- 13
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hi,
I am trying to define two new measures for the table ToetsingNaf in PBI, but it does not let me do that.
The worksheet has two tables which I imported into PBI.
For the table ToetsingNaf I had to make two new columns Verschil 1 and Verschil 2 (formatted as %).
Verschil 1 = (ToetsingNaf[Tot_inv_Naf]- ToetsingNaf[GgM-Naf])/ToetsingNaf[Tot_inv_Naf]
Verschil 2 = (ToetsingNaf[GgM-Naf]-ToetsingNaf[Gg_Gdoc_Naf])/ToetsingNaf[GgM-Naf]
Instead of the new calculated columns I wanted to define two measures Verschil 1 and Verschil 2 instead of the columns.
Why can't I make these measures?
I am trying to define two new measures for the table ToetsingNaf in PBI, but it does not let me do that.
The worksheet has two tables which I imported into PBI.
For the table ToetsingNaf I had to make two new columns Verschil 1 and Verschil 2 (formatted as %).
Verschil 1 = (ToetsingNaf[Tot_inv_Naf]- ToetsingNaf[GgM-Naf])/ToetsingNaf[Tot_inv_Naf]
Verschil 2 = (ToetsingNaf[GgM-Naf]-ToetsingNaf[Gg_Gdoc_Naf])/ToetsingNaf[GgM-Naf]
Instead of the new calculated columns I wanted to define two measures Verschil 1 and Verschil 2 instead of the columns.
Why can't I make these measures?
Attachments
Last edited: