undefined

Hi akash0800 ,

Here I suggest you to add a NetWorkday column in your calendar table. It should look like as below.

For reference: NETWORKDAYS function (DAX) - DAX | Microsoft Learn

In my sample, 2022/01/21 is a holiday, so there are 20 working days in Jan.

Networkday = NETWORKDAYS('Calendar'[Date],'Calendar'[Date],1,{DATE(2022,01,21)})

 Measure:

Measure = DIVIDE([Revenue],SUM('Calendar'[Networkday]))

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you this worked.

As suggested. I added the network days to date table using Lookup function and then created a measure as suggested. It worked.

Thanks for the support.