Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have an issue with a measure i try to create for calculating the profit target as 10% higher than the previous month's profit.
So I create a measure like this
Solved! Go to Solution.
Hi all
thanks for your help
The issue now is fixed, after i applied my Windows settings to match the ones of Power BI.
For Windows i had comma (,) as decimal seperator and this seems to have been overruling the settings of Power BI
Christina
Hi all
thanks for your help
The issue now is fixed, after i applied my Windows settings to match the ones of Power BI.
For Windows i had comma (,) as decimal seperator and this seems to have been overruling the settings of Power BI
Christina
Hi,
Share the download link of the PBI file and show the problem there clearly.
Hi Christina;
I've tried to create a measure the exact same way you did with your [Target Area] and it worked fine on my laptop.
So I would need to see how you created the measue [Previous Month Profit] in order to better understand what may not going well with measure [Profit Target].
Hi
thanks!
that's the previous month profit measure
Hi,
Insteade of using "DATEADD", have you tried using PREVIOUSMONTH?
It would be like this:
Hi
same issue... 😞
Maybe, using VARs...
*Copy and Paste the following DAX on your [Target Area] measure*
Hi
same issue. As long as i try to type in any decimal number it ignores the decimal and multiplies anything with 11
Christina
Hi, Christina;
Please, go to "File" > "Options and Settings" > "Options" > "Regional Settings"
Then, check the first option in "DAX separators" as you can see on image:
Hope this helps 🙂
Hi flath
it is already selected like this
thanks
Hi
That's strange, seems to be some locale issue. As a workaround you could :
[Previous Month Profit] * 110/100
Hope this helps
JJ
Hi Jj
thanks!
i did that already as a workaround but just was wondering if there is an actual fix
Christina
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
158 | |
125 | |
76 | |
74 | |
63 |