counter

3 Topics

DAX columns for date when sales target was reached by staff and number of days worked reach target
I woulkd be so greatful, if one of the DAX experts can help with a DAX formula for 2 columns I want to create. I have 2 tables. table 1 is called 'Staff' with 4 staff (A to D) in colum Staff, there are columns for Items Sold, Days Worked, Days To Meet Target and Date Target Met. The related table is called 'Rota' has columns Staff, Items Sold and Date Worked. I need a DAX to formula for 3 additional columns in Staff table: Days Worked, this will count number of days each staff has worked. Days To Meet Target, work out the number of days staff worked to meet the target of 6 sales, ignoring days after target reached. Date Target Met, this will find the date when staff reached their target of 6 sales, ignoring days after target was reached. In the Staff Table below, Staff 'C' shows them meeting target of 6 after working 1 day, they met thier target on 2nd Feb, they worked 2 days in total. Staff 'D' shows them meeting target of 6 after working 2 days, the 2nd day they worked was 4th April, they worked 3 days in total. Staff Staff Items Sold Days Worked Days To Meet Target Date Target Met A 3 2 B 2 1 C 9 2 1 02-Feb-20 D 7 3 2 04-Apr-20 Rota Staff Items Sold Date Worked A 1 13-Jan-20 C 6 02-Feb-20 B 2 14-Feb-20 D 3 18-Feb-20 A 2 21-Mar-20 D 3 04-Apr-20 C 3 05-Jun-20 D 1 01-Jul-20
Solved
Gangsta
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
3Comments
How to create an increment counter column based on how many entries a same person submit
Hi everyone. Can somebody help me? I am a beginner at Power BI. The scenario is I have a table that stores data of entries submitted by employees. I want to create a column that counts incrementally whenever the same person submits an entry. The example that I want is as below: STAFF NAME COUNTER COLUMN Hanis 1 Hanis 2 Faiz 1 Amira 1 Hanis 3 Syafiq 1 Faiz 2 As you can see above, when 'Hanis' submit her first entry ever, the counter starts with one. Then when she submit more entry, the counter increments. The same goes for 'Faiz'. Can anybody help me to create this counter column? TQ in advance!
Anonymous
3 years ago Place DAX Commands and Tips
3.4KViews
0likes
4Comments
Increase Count on Status & Product Change
Hello All, Product and Status is the columns i have and need data in column Group as output. Group number to change when the status changes and Product changes Could you please help with the DAX query Ashish_Mathur - I could see you have helped on similar query. Could you please assist on this one Product Status Group Soap Approved 1 Soap Approved 1 Soap Removed 2 Soap Removed 2 Soap Sales 3 Soap Removed 4 Soap Others 5 Soap Removed 6 Soap Removed 6 Soap Removed 6 Soap Removed 6 Soap Removed 6 Soap Others 7 Soap Others 7 Soap Others 7 Box Approved 1 Box Removed 2 Box Removed 2 Box Others 3 Box Sales 4 Box Sales 4
Solved
SethuPower
7 years ago Place DAX Commands and Tips
2.3KViews
0likes
4Comments