Forum Discussion

FredLEGUEN's avatar
FredLEGUEN
Icon for Helper III rankHelper III
5 years ago

Search between 2 account number

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 measure...
Need Help
amolrs's avatar
amolrs
Frequent Visitor
5 years ago

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