Forum Discussion
Solved
Syntax Error
Good morning, I created these formulas with conditionals to meet the needs, they work perfectly in the local PowerBI but when trying to use this code in APP.POWERBI to introduce in the data flow i...
Hi marcelfirk
Are you going to add two columns to a table in a Power BI dataflow? If so, this can be done with M code.
You can add two custom columns with below code
if [Vencimento real] > 2021 and [Coligada do aluno] = "34" and [Filial do aluno] = "1" then "999" else [Coligada do aluno]if [Vencimento real] > 2021 and [Coligada do aluno] = "34" and [Filial do aluno] = "1" then "999" else [Coligada do aluno]Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi marcelfirk
You talk about Dataflows, which uses M like Power Query, but the code you show is DAX
Can you clarify?
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |