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([R...
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
)
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

      • elenita62's avatar
        elenita62
        Frequent Visitor
        9 years ago

        When I do it in this way, the group is totally lost and I get my result and the other data from another rows... 

        See the image: