DAX Formula

[prasannakrishna]

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

[v-chuncz-msft · Accepted solution]

@prasannakrishna,

You may try using CALENDAR Function and WEEKDAY Function.

https://community.powerbi.com/t5/Desktop/DATEDIFF-Working-Days/td-p/130662