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

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
)
elenita62's avatar
elenita62
Frequent Visitor
9 years ago

Thank you soo much!!! It worked fine!