Reply
Christina_R
Regular Visitor
Partially syndicated - Outbound

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

Profit Target =
[Previous Month Profit] * 1.1
 
But unfortunately what it actually calculates is [previous Month Profit] * 11!!!
How can i fix this?
 
Many thanks!
Christina
1 ACCEPTED SOLUTION
Christina_R
Regular Visitor

Syndicated - Outbound

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

View solution in original post

12 REPLIES 12
Christina_R
Regular Visitor

Syndicated - Outbound

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

Ashish_Mathur
Super User
Super User

Syndicated - Outbound

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/
flath
Helper II
Helper II

Syndicated - Outbound

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].


Syndicated - Outbound

Hi 

thanks!

that's the previous month profit measure

 

Previous Month Profit =
CALCULATE(
    [Total Profit],
    DATEADD(
        'Calendar Lookup'[Date],
        -1,
        MONTH
    ))

Syndicated - Outbound

Hi,

Insteade of using "DATEADD", have you tried using PREVIOUSMONTH?

It would be like this:

CALCULATE(
    [Total Profit],
    PREVIOUSMONTH('Calendar Lookup'[Date])
    )




Syndicated - Outbound

Hi

same issue... 😞

Syndicated - Outbound

Maybe, using VARs...
*Copy and Paste the following DAX on your [Target Area] measure*

Profit Target =
VAR PreviousProfit = [Previous Month Profit] 
VAR increase = 1.1

RETURN PreviousProfit * increase

Syndicated - Outbound

Hi

 

same issue. As long as i try to type in any decimal number it ignores the decimal and multiplies anything with 11

 

Christina

Syndicated - Outbound

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:

power-bi-dax-separators.png

Hope this helps 🙂

Syndicated - Outbound

Hi flath

it is already selected like this

 

thanks

DoubleJ
Solution Supplier
Solution Supplier

Syndicated - Outbound

Hi
That's strange, seems to be some locale issue. As a workaround you could : 
[Previous Month Profit] * 110/100

Hope this helps
JJ

Syndicated - Outbound

Hi Jj

thanks!

i did that already as a workaround but just was wondering if there is an actual fix

 

Christina

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)