Forum Discussion
Calculation assistance with DAX
Hi,
Need a assistance i have attached sheet from which i need the number of 1080 with DAX. sample is attached in below link
8 Replies
Can you be more specific on what you want? I see from your excel file that you have a "Grand Total" row that is summing the values in the "Target Mandays" column.
Is this the value you are looking for? Are you saying you need help with a DAX formula to recreate this value in a Power BI file?
- So i have 2 sheets
1- is of sales data
2- is of headcount sheet which tells me how many sales promoters are need to be deployed on specific brand on each day
So, i need to perform a calculation on sales data that like:
1- how many dates are there in sales data on which brand sales promoters have worked
E.g brand mlb has 7 working days (distinct count of days)
Now i need to multiply 7 working days with for mlb brand and lookup in to head count sheet how many headcount is need to be deployed which is 6 so (7*6)=42
And this calculation will goes on for brand in every region.It looks like you have all of the measures completed already. I just created a pivot table and added the columns you have selected for each region by brand. Is this what you are looking for? See sheet 2 with pivot table.
