Forum Discussion

balumaran's avatar
balumaran
Frequent Visitor
9 years ago

Conditional Columns or IF Conditions in Direct Query mode

Hello Experts,  Looking for help here. I have a report that pulls data from 11 mil rows and 10 mil rows SAP HANA views in direct query mode. I understand that there are limitations in Direct Query m...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

balumaran,

 

For your Dimensional attrinbute, it's better to create a column other than a measure. I have tested it on my local environment, connect to SAP HANA.

Column = IF(RaduSales[EnglishProductName]="Bikes","A","B")
Measure 2 = if(SUM(RaduSales[SalesAmount])>50000000,"Good","N/A")

 

If your issue persists, please provide us more detail information, so that we can make further analysis.

 

Regards,

Charlie Liao