selected value & Previous Month

[ismails]

Hi expert,

I have a concern to take data workingdays previous month, my structure data like below. can i get previous month working days on Feb (20 workingdays)?? please advice ....

thanks

[v-frfei-msft]

Hi @ismails,

Here I made an sample to meet your requirement, We can create a measure as below.

workdayst = CALCULATE(SUM(Table1[Working days]),DATEADD(dimtime[Date],-1,MONTH))

For more details, please check the pbix as attached. If it doesn't meet your requirement, kindly share your pbix to me.

https://www.dropbox.com/s/h7hhxd49zc15839/selected%20value%20%26%20Previous%20Month.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @ismails,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,

Frank