Pick up String by starting the count from right right or from end

[rds_2019]

Hi,

I want to take the String from a field by countfrom the right but not able to.

I want to do below From Field, Rerquired1 and Required 2 or trhe fields. I have to count from right end of the String to identify the reuired String:- 

Field	Required 1	Required 2
abc_22_201909	2019	9
abc_201908	2019	8
aaa_dd_201907	2019	7

[Anonymous · Accepted solution]

Required1 = LEFT(RIGHT(tbl[Field ],6),4)

Required2 = RIGHT(tbl[Field],2)

[rds_2019]

@Anonymous , This is how i have done it but i am sure there must be some direct way we can get this done .I mean direct DAX query which can be used instead of usig RIGHT and then LEFT.

Cheers,

RDS