Search between 2 account number

[FredLEGUEN]

Hi community,

I'm building a report for an accounting company

Most of the DAX measures are easy to write. Like this one

CALCULATE([SommeC];SourceAccess[Comptes]="74000000")

But some measures must calculate the sum for all the values between 2 account number.

My account numbers are in text format in my source file. So I can't write a measure like this

CALCULATE([SommeC];SourceAccess[Comptes]>="64110000"||SourceAccess[Comptes]<="64145000")

Any thoughts?

[v-angzheng-msft]

May I ask if your problem has been solved? Is the above answer helpful to you?
If it helps, could you please mark the response which help as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

[FredLEGUEN]

Hi @amolrs ,

You're right

With Power Query, I just had to duplicate the column and change the format column.

Now, I have to correct most of my measures 😉 

[amolrs]

@FredLEGUEN , you can change the data type for the existing column itself. Then you will not have to correct your existing measures.

[amolrs]

Hi @FredLEGUEN ,

How about changing the data type of Account Number to Whole Number and then trying the formula you suggested.

The formula needs to be changed to include the && operator instead of || to something like:

CALCULATE([SommeC];SourceAccess[Comptes]>="64110000" && SourceAccess[Comptes]<="64145000")

Cheers,

Amol