- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DAX formula not recognizing period (.)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Share the download link of the PBI file and show the problem there clearly.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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].
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
thanks!
that's the previous month profit measure
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Insteade of using "DATEADD", have you tried using PREVIOUSMONTH?
It would be like this:
PREVIOUSMONTH('Calendar Lookup'[Date])
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
same issue... 😞
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe, using VARs...
*Copy and Paste the following DAX on your [Target Area] measure*
VAR increase = 1.1
RETURN PreviousProfit * increase
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
same issue. As long as i try to type in any decimal number it ignores the decimal and multiplies anything with 11
Christina
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi flath
it is already selected like this
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
That's strange, seems to be some locale issue. As a workaround you could :
[Previous Month Profit] * 110/100
Hope this helps
JJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jj
thanks!
i did that already as a workaround but just was wondering if there is an actual fix
Christina
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
03-29-2024 08:36 PM | |||
09-04-2024 05:04 AM | |||
07-23-2024 06:36 AM | |||
07-31-2024 11:01 AM | |||
08-13-2024 10:15 AM |
User | Count |
---|---|
128 | |
81 | |
59 | |
57 | |
43 |
User | Count |
---|---|
183 | |
111 | |
82 | |
66 | |
51 |