topic Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax in DAX Commands and Tips

Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

firstch — Mon, 15 Aug 2022 05:06:43 GMT

Hi all ,

Is there any way to get last to of value in slicer that is text, then convert to int and use in this DAX

my sample data please refer to this post:https://community.powerbi.com/t5/DAX-Commands-and-Tips/Is-there-any-way-to-get-Last-Year-value-with-this-kind-of-filter/m-p/2693976#M81198

Best Regard
firstch

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

daXtreme — Mon, 15 Aug 2022 06:26:17 GMT

firstch

Generally, it's a bad idea. There's a much better one. In the table from which your slicer's values come put another column where the entries will already be in the right format and type. You can hide this column as it's going to be meant for your measure(s) only. Then you'll be able to retrieve the number straight from the table instead of calculating it and wasting CPU cycles (making DAX slower and more complex than it needs to be).

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

tamerj1 — Mon, 15 Aug 2022 06:30:18 GMT

Hi firstch
In your code: LEFT ( 'table a'[custom], 2 ) will return 25 for all the rows in the sample data. Would you please provide the eaxpected result as per the same sample data?

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

firstch — Mon, 15 Aug 2022 06:35:32 GMT

dear tamerj1

it would be RIGHT ( 'table a'[custom])

best regard

firstch

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

tamerj1 — Mon, 15 Aug 2022 06:49:52 GMT

firstch
Here is a sample file with the solution https://www.dropbox.com/t/SDqoISRmW1vgAF0a

Value Last Year = VAR SelectedProductionYear = MAX ( 'Table A'[productionYear] ) VAR SelectedYear = VALUE ( RIGHT ( SelectedProductionYear, 2 ) ) VAR LastProductionYear = LEFT ( SelectedProductionYear, 2 ) & SelectedYear - 2 & "/" & SelectedYear - 1 VAR Result = CALCULATE ( SUM ( 'Table A'[value] ), 'Table A'[productionYear] = LastProductionYear ) RETURN Result

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

firstch — Mon, 15 Aug 2022 07:24:07 GMT

daXtreme thankyou for your suggestion

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

firstch — Mon, 15 Aug 2022 07:42:46 GMT

hi tamerj1

thankyou ,its work for me now, but if it possible that when user

select all in filter can you make the lastyear card to be blank?

best regard

firstch

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

tamerj1 — Mon, 15 Aug 2022 07:43:29 GMT

Hi firstch

do you mean in case of multiple selections or only in the case where all the filter is selected?

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

firstch — Mon, 15 Aug 2022 08:18:50 GMT

tamerj1

in case of all filter ,currently when select all its show data of year 2564/65 sir

best regard

firstch

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

tamerj1 — Mon, 15 Aug 2022 08:53:26 GMT

firstch
Sorry, I was not on my desk. Here is the updated file https://www.dropbox.com/t/oNRuMlL6NSzUdJhu

Re: Is there any way to get last to of value in slicer that is text, then convert to int and use in dax

firstch — Mon, 15 Aug 2022 09:19:04 GMT

Hi tamerj1 Thankyou so much for your help,

Best Regard

firstch