Forum Discussion
selected value & Previous Month
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
2 Replies
v-frfei-msftCommunity Support
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