Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Hi @ismails,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |