Hi
Stuck in while counting no of each week day in selected period
tried this to count total Saturday SatTot:=calculate(countrows('date'[Date]),filter(weekday('date'[Date])=1))
My ultimate aim to break the Sales Target in days, My Target sheet tab is like
StoreCode | Date | Tot Target | Sun | Mon| Tue | Wed| Thu| Fri| Sat
Store Code : Unique code
Date : date entered as 1st of month ie 1/4/2016 for April
Tot Taget : Total target for the month Eg. 48,000
Sun : Contribution % of Sunday Target Eg 3.5%
Mon : Contibution % of Monday Target Eg 3% so.. on
assume when I select 3rd Apr to 11th April calculation should be
48000* ((Sun*2)+(Mon*2)+(Tue*1)+(Wed*1)+(Thu*1)+(Fri*1)+(Sat*1)) Here 1 and 2 represent howmay week days between the selected date.
how can this formulate in DAX
Stuck in while counting no of each week day in selected period
tried this to count total Saturday SatTot:=calculate(countrows('date'[Date]),filter(weekday('date'[Date])=1))
My ultimate aim to break the Sales Target in days, My Target sheet tab is like
StoreCode | Date | Tot Target | Sun | Mon| Tue | Wed| Thu| Fri| Sat
Store Code : Unique code
Date : date entered as 1st of month ie 1/4/2016 for April
Tot Taget : Total target for the month Eg. 48,000
Sun : Contribution % of Sunday Target Eg 3.5%
Mon : Contibution % of Monday Target Eg 3% so.. on
assume when I select 3rd Apr to 11th April calculation should be
48000* ((Sun*2)+(Mon*2)+(Tue*1)+(Wed*1)+(Thu*1)+(Fri*1)+(Sat*1)) Here 1 and 2 represent howmay week days between the selected date.
how can this formulate in DAX
