Forum Discussion
Solved
Date error
I had to change an excel file to sharepoint list. Now my formulas in Power Bi show wrong results I changed regional configuration in sharepoint list and power bi but didn't work. My formula: ...
AleMacedo , Try with these modifications
Projetos Finalizados no Prazo =
SWITCH (
TRUE (),
isblank(max(cadProjetos[DataConclusãoPrevista])), UNICHAR(63),
isblank(max(cadProjetos[DataTérminoReal])), UNICHAR(63),
max(cadProjetos[DataTérminoReal])<=max(cadProjetos[DataConclusãoPrevista]), UNICHAR(9989),
UNICHAR (9949)
)
I think that it was same error with unicode . I changed them (codes) and worked. Thank you all!