Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ramees_123
Helper IV
Helper IV

DAX Measure to check Timesheet submission behaviour

Hi, I have the below table details of the employees time sheet submission. Need to create a measure for a bar chart to see how much employees are in below categories.

 

1) Last one month Non-Compliant or Partially Compliant

2) Last two months Non-Compliant or Partially Compliant

3) Last three months Non-Compliant or Partially Compliant  

 

DateEmployee IDTime_Sheet
01/09/20211Non-Compliant
01/08/20211Compliant
01/07/20211Partially Compliant
01/06/20211Compliant
01/05/20211Compliant
01/09/20212Non-Compliant
01/08/20212Non-Compliant
01/07/20212Non-Compliant
01/06/20212Non-Compliant
01/05/20212Non-Compliant
01/09/20213Partially Compliant
01/08/20213Non-Compliant
01/07/20213Non-Compliant
01/06/20213Compliant
01/05/20213Compliant
01/09/20214Compliant
01/08/20214Compliant
01/07/20214Compliant
01/06/20214Compliant
01/05/20214Compliant
1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @Ramees_123 ,

According to your description, I create columns, if you prefer measure, you can use measure=SUM([Column]).

 

vkalyjmsft_0-1637044342339.png

vkalyjmsft_1-1637044342341.png

vkalyjmsft_2-1637044342343.png

 

Best Regards,
Community Support Team _ kalyj

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

View solution in original post

4 REPLIES 4
v-yanjiang-msft
Community Support
Community Support

Hi @Ramees_123 ,

According to your description, I create columns, if you prefer measure, you can use measure=SUM([Column]).

 

vkalyjmsft_0-1637044342339.png

vkalyjmsft_1-1637044342341.png

vkalyjmsft_2-1637044342343.png

 

Best Regards,
Community Support Team _ kalyj

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

Ashish_Mathur
Super User
Super User

Hi,

Based on the data that you have shared, please show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Last Three Months Non Compliant or Partially Compliant - 3 employees (IDs 1,2 and 3)

Last Two Months Non Compliant or Partially Compliant - 0

Last one month Non Compliant or Partially Compliant - 0

Hi,

Today is November 14.  What time period are you referring to when you mention last 3 months?  Is it 3 months ended the last day of the previous month? 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.