Forum Discussion

ph's avatar
ph
Helper I
7 years ago
Solved

function LEFT as measure

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 ...
  • ph's avatar
    ph
    7 years ago

    Hi Mariusz 

     

    I would like get something like this

     

    Batch No.LEFT(Batch No.;3)
    123123123
    123456123
    123789123
    987987987
    987654987
    987321987

     

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

  • Mariusz's avatar
    Mariusz
    7 years ago

    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 Repczynski

     

  • Anonymous's avatar
    Anonymous
    7 years ago
    [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.

Mariusz's avatar
Mariusz
Community Champion
7 years ago

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 Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago
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