Percentage of 2 columns Dax formula not working

[c5966]

Column D = (Column B/Column C)*100

Hi Team,

I would like to get help with Dax formula for 4th column, which is = (Column B/Column C)*100

Also these rows are running rows, data changes daily with date (last 1 day of data).

I tried couple of formulas but getting different percentages every time.

Appreciate your help in advance.

Thank you.

[Greg_Deckler]

OK, so the % in the last column appear to be correct to me, so is this the desired state? If so, what does your source data look like?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[c5966]

Yes Column D is the desired output.

This is sample data in excel - above screenshot.

How do we get that percentage through Dax formula is my actual question?

Appreciate your help.

Thank you.