Forum Discussion
prasannakrishna
7 years agoNew Member
DAX Formula
HI Team
I need a dax that, i have QTD value and and i want to calculate tracking on value of QTD
Tracking on = QTD/(no of sales days completed * 62) . and i want to change no of sales days depends on date.
if today is 10/15 do no of sales days is 10 out of 62, if today got completed then no. of sale s days is 11 of 62
ina fiscal qy=uater we have 62 sales days by skipping saturday and sundays.
can i get any help in dax\.
Thankyou
krishna
1 Reply
- v-chuncz-msftCommunity Support