Forum Discussion

elenita62's avatar
elenita62
Frequent Visitor
9 years ago
Solved

Excel Formula to PowerBI

Hi, I am new here... 

 

I have this formula in Excel +P12/N12-1, and now I am trying to use it en PowerBI desktop and it doesn't work.

 

My calculated formula in PowerBI  is> Base = DIVIDE(sum([R15-16]),sum([R14-15]),0) and I need to add the -1 

 

Hope you can help me!

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    I may be mixing up blank/zero parsing... Try

     

    Base = IF(
	ISBLANK(SUM([R14-15])),
	BLANK(),
	DIVIDE(
		SUM([R15-16]),
		SUM([R14-15]),
		0
	) - 1
)

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Have you tried literally just adding the -1 to the formula?

    • elenita62's avatar
      elenita62
      Frequent Visitor
      9 years ago

      Sure, but then I lost the group and 

       

      See the results:

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

         Base = DIVIDE(sum([R15-16]),sum([R14-15]),0) - 1