Forum Discussion

SteveKingdon's avatar
SteveKingdon
Frequent Visitor
4 years ago

Adding fixed costs to daily data

Hi,   I have daily wage costing in BI and I want to add some fixed cost to this daily figure. I then want to be able to filter the new total cost over various time frames. I current do not have thi...
fixed costs
SteveKingdon's avatar
SteveKingdon
Frequent Visitor
4 years ago

Hi Thanks for this. Just wondering what the 1.300 is representing?

 

Can the values 1.200 be held in a table any where and be referenced or does it have t be in the DAX code?

 

So that if some one who is not a BI dax user can update and the report will update accordingly?

 

Thanks


Steve

SteveKingdon's avatar
SteveKingdon
Frequent Visitor
4 years ago

Hi,

 

This has sort of solved my problem. However it is over allocating. The data I am adding this is total from multple empoyees work £xxs earned  a day. 

 

I need to work out

Total pay for a team (totals multiple peoples pay under a total cost for the team) - done

I need to work this daily and over a fixed time frane 1-xx days - done

Allocation of the fixed cost to the team - not done. The code above is allocating the fixed cost multiple times when I need it to be allocated once per day to the team (then summed if required over mutiple days).

 

I hope this makes sense?

 

Steve

cating