Forum Discussion

Pricey79's avatar
Pricey79
Helper V
3 years ago
Solved

VALUE or FORMAT error with the same Data Types Help please

Can anyone please help, this is driving me mad   I have a measure as below, and I'm getting the 'Consider using the VALUE or FORMAT' error   I've triple checkled and all data types are dates   ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Pricey79 , N/A trying make it as test,  both then and else should be text

     


    Measure =
    COALESCE(divide( CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])),
    'Table 1'[record_id] <= 'Table1'[due_date])
    ,
    CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])))), blank() )

     

     

    or


    Measure =
    COALESCE(divide( CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])),
    'Table 1'[record_id] <= 'Table1'[due_date])
    ,
    CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])))) & "", "N/A")

amitchandak's avatar
amitchandak
Super User
3 years ago

Pricey79 , N/A trying make it as test,  both then and else should be text

 


Measure =
COALESCE(divide( CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])),
'Table 1'[record_id] <= 'Table1'[due_date])
,
CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])))), blank() )

 

 

or


Measure =
COALESCE(divide( CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])),
'Table 1'[record_id] <= 'Table1'[due_date])
,
CALCULATE(COUNTA('Table1'[record_id]) ,NOT(ISBLANK('Table1'[date_closed])))) & "", "N/A")