Forum Discussion

prasannakrishna's avatar
prasannakrishna
New Member
7 years ago
Solved

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