cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GeorgesKV Regular Visitor
Regular Visitor

Re: Calculate % divide by a fixed monthly number

The measure is doing this:

Excel: 165/160 = 105%
PBI: 165/160 = 10.4%

The problem is that Power Bi is showing 10.4 instead of 104% and I don't know why.

GeorgesKV Regular Visitor
Regular Visitor

Re: Calculate % divide by a fixed monthly number

@chirayuw is it possible to make a filter in that DAX you sent me in the sample for Holiday where instead of 0 it counts as 4?

Regards,

chirayuw Member
Member

Re: Calculate % divide by a fixed monthly number

Hi, Edited the formula in the Calendar Table to say 4 for Sat/Sun/ Holiday. Or do you want Sat + Sun as 0 but Holiday as 4

 

Also I've almost redone the file because I was trying to fix the issue of not going above 100%

 

Have a look and let me know if this is what u need

 

https://ufile.io/jc0o0

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 2,378 guests
Please welcome our newest community members: