function LEFT as measure

[ph]

Hi,

I need to use LEFT() function for each row in table so as a measure in 'row context'. Because my report is based on powerBI dataset, I am unable to use LEFT() as a new column (this operation is unavailable)

Any idea how to do it?

thx a lot !

[ph · Accepted solution]

Hi @Mariusz 

I would like get something like this

Batch No.	LEFT(Batch No.;3)
123123	123
123456	123
123789	123
987987	987
987654	987
987321	987

But I cannot solve it as 'new column', where it is easy to set up

[Mariusz · Accepted solution]

Hi @ph 

Please see the below

Measure = LEFT( MAX( 'Table'[Batch No.] ), 3 )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Mariusz]

Hi @ph 

Can you provide a data sampe?

Best Regards,
Mariusz

Please feel free to connect with me.

[ph · Accepted solution]

Hi @Mariusz 

I would like get something like this

Batch No.	LEFT(Batch No.;3)
123123	123
123456	123
123789	123
987987	987
987654	987
987321	987

But I cannot solve it as 'new column', where it is easy to set up

[Anonymous · Accepted solution]

[First 3 Chars for Batch No.] =  -- measure
var __oneBatchVisible = HASONEFILTER( T[Batch No.] )
var __chars =
	if (
		__oneBatchVisible,

		var __currentBatch = VALUES( T[Batch No.] )
		var __first3Chars =
			left( __currentBatch, 3 )
		return
			__first3Chars
	)
RETURN
	__chars

Best

D.

[ph]

Hi both

thank you for your help 🙂 

I accept as solution the first one, because it is easier to understand it, second one is more complicated ..but works fine !!

[Mariusz · Accepted solution]

Hi @ph 

Please see the below

Measure = LEFT( MAX( 'Table'[Batch No.] ), 3 )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

The measure proposed by Mariusz is not too informative when there is more than 1 Batch No. in scope. The usefulness of it is hampered by the fact that when no Bach No. has been explicitly selected, it'll still return... something. What is this something? Well, it's the first 3 letters from the Batch No. that is the max number out of the visible numbers in the current context. Not sure if this is of any use.

Measures should be defined in such a way that they make sense when they are displayed and when it makes no sense for them to appear, they just return BLANK.

Best
Darek