Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
@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!
I create 2 new columns in sharepoint list to return "yes" or "no" to question: "On time?"
what I have to change in formula to compare texts?
If column= "yes" then show UNICHAR ( 9989 ), if column = "no", show UNICHAR ( 9949 ), if is blank() shows UNICHAR(63)?
Hi @AleMacedo
Do you want to change your data source from excel to sharepoint list, and the measure you built will show wrong result after you change your data source?
You build a measure by switch function. In No prazo?, all icons are unichar(9989). I need to know your data and data model. Could you share me a sample file by Onedrive for Business that will show error in measure? And it is better for you to show me the result you want by screenshot. This will make it easier for me to understand your measure logic.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
nope, same error.
@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)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |