Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all,
I try to do below formulation but still getting error.
Step I already try
1. if[#"SAP_MMT_LV_MKPF_EN.D/C_SHKZG"]="H" then Value.Multiply([Quantity_MENGE],-1) else [Quantity_MENGE]
2. if[#"SAP_MMT_LV_MKPF_EN.D/C_SHKZG"]="H" then [Quantity_MENGE]*(-1) else [Quantity_MENGE]
3. I change the data type for [Quantity_MENGE] from number to text
Regards,
Nuha
Solved! Go to Solution.
Replace [Quantity_MENGE] with
Number.From( [Quantity_MENGE])
Having this error
PQ is super sensitive to case. You have written number.from
It has to be
Number.From
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |