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

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

  • flath's avatar
    flath
    Helper II
    3 years ago

    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 🙂

    • Christina_R's avatar
      Christina_R
      Regular Visitor
      3 years ago

      Hi flath

      it is already selected like this

       

      thanks