Forum Discussion

qlnv's avatar
qlnv
New Member
4 years ago
Solved

A Single value for column in table cannot be determined

Hi, I'm trying to create a column/measure in direct query mode but it doesn't work. (it works in imported mode).  The error:    A single value for column 'NGAY_HL' in table 'BI_XE_HOP_DONG' canno...
  • amitchandak's avatar
    amitchandak
    4 years ago

    qlnv , This should work as a column , In case of measure you need to use aggregation on column or use them inside x functions 

    DELTA_NGAY = sumx('BI_XE_HOP_DONG',  if(DATEDIFF('BI_XE_HOP_DONG'[NGAY_HL], TODAY(), DAY) > 0, IF(DATEDIFF('BI_XE_HOP_DONG'[NGAY_HL], TODAY(), DAY)>'BI_XE_HOP_DONG'[PERIOD], 'BI_XE_HOP_DONG'[PERIOD],DATEDIFF('BI_XE_HOP_DONG'[NGAY_HL], TODAY(), DAY)) ,0))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

qlnv , This should work as a column , In case of measure you need to use aggregation on column or use them inside x functions 

DELTA_NGAY = sumx('BI_XE_HOP_DONG',  if(DATEDIFF('BI_XE_HOP_DONG'[NGAY_HL], TODAY(), DAY) > 0, IF(DATEDIFF('BI_XE_HOP_DONG'[NGAY_HL], TODAY(), DAY)>'BI_XE_HOP_DONG'[PERIOD], 'BI_XE_HOP_DONG'[PERIOD],DATEDIFF('BI_XE_HOP_DONG'[NGAY_HL], TODAY(), DAY)) ,0))