Forum Discussion

Christina_R's avatar
Christina_R
Regular Visitor
3 years ago
Solved

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 Mo...
Need Help
  • Christina_R's avatar
    Christina_R
    3 years ago

    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

Christina_R's avatar
Christina_R
Regular Visitor
3 years ago

Hi 

thanks!

that's the previous month profit measure

 

Previous Month Profit =
CALCULATE(
    [Total Profit],
    DATEADD(
        'Calendar Lookup'[Date],
        -1,
        MONTH
    ))
flath's avatar
flath
Helper II
3 years ago

Hi,

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

It would be like this:

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




  • Christina_R's avatar
    Christina_R
    Regular Visitor
    3 years ago

    Hi

    same issue... 😞

    • flath's avatar
      flath
      Helper II
      3 years ago

      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
      • Christina_R's avatar
        Christina_R
        Regular Visitor
        3 years ago

        Hi

         

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

         

        Christina