please help

10 Topics

Date value available, still returns as Blank
Hi All. I am facing a very strange situation where I have one table which has around 17k records & each record has date value and the data type is Date too. I want to write one measure based on the date but it is not giving the desired result as date field treated as blank. Below is the actual screenshot. I tried with MAX,MIN also, still same result. The below table visual values are coming from same table, so no issue of Relationship.
Solved
MangeshVC
2 years ago Place DAX Commands and Tips
526Views
0likes
2Comments
RSCustomDaxFilter - Paginated Report
Hi Team, I'm working on paginated report. I want to make Last Name and Worker Id parameters optional. User can seleter either Worker Id or Last Name. Can you please help me add a Or conditon in RSCustomDaxFilter? In case user selects Work Id, Last Name should be passed as null. EVALUATE SUMMARIZECOLUMNS('Sample Data'[First Name], 'Sample Data'[Last Name], 'Sample Data'[Worker ID], 'Sample Data'[License Number], 'Sample Data'[Jurisdiction], 'Sample Data'[JurisdictionDesc], 'Sample Data'[Company Name], 'Sample Data'[EmployeeOfficeLocation], 'Sample Data'[Processing Date], 'Sample Data'[Author/Content Credits], 'Sample Data'[Instructor Credits], 'Sample Data'[Learner Credits], 'Sample Data'[Carry Applied], 'Sample Data'[Rule Applied], 'Sample Data'[subjectType], 'Sample Data'[courseCode], 'Sample Data'[providerRegistryNumber(Sponsor ID)], 'Sample Data'[providerName], 'Sample Data'[courseLocationState], 'Sample Data'[Multi-Year RP End Date], 'Sample Data'[Multi-Year RP Start Date], 'Sample Data'[courseDateEnd], 'Sample Data'[courseDateStart], 'Sample Data'[courseDeliveryMethod], 'Sample Data'[courseName], 'Sample Data'[Limitation Reason], RSCustomDaxFilter(@SampleDataLastName,EqualToCondition,[Sample Data].[Last Name],String), RSCustomDaxFilter(@SampleDataJurisdictionDesc,EqualToCondition,[Sample Data].[JurisdictionDesc],String), RSCustomDaxFilter(@SampleDataWorkerID,EqualToCondition,[Sample Data].[Worker ID],String)) Thanks, Fayyaz
Anonymous
2 years ago Place DAX Commands and Tips
12KViews
0likes
4Comments
Facing an Error while trying to connect Power BI with MySQL workbench
Hi Power BI community, I have MySQL Workbench in that i have two connections. one is the Localhost and one is the other server. when I try to connect the Local Host to the Power BI i am getting an Error. and When I try to connect the other server to the Power BI i am getting a different Error. please help me with this Error. Thanks & Regards, Ibrahim Shaik
Ibrahim_shaik
3 years ago Place DAX Commands and Tips
316Views
0likes
0Comments
I can't make a dax for calculating bonus
Hello everyone, I got a difficult problem. I have 2 table with data and some conditions for calculating bonus of employee. Please help me to find the measure for calculating this bonus. Table 1 : Campus Code User Name Area Code Enquiries # of New Student PD Target New Enrol PD % Act vs Target New Revenue PD Month ADV ADV MiddleArea 56 45 28 161% 524,865,000 Jan BD-CMT8 BD-CMT8 SouthArea 13 6 12 50% 71,233,000 Jan HCM_NK2 HCM_NK2 NorthArea 40 47 35 134% 528,058,000 Jan Table 2 : Campus Code User Name Area Code Enquiries # of New Student PD New Revenue PD Month ADV Jame MiddleArea 31 30 318,159,000 Jan ADV Mary MiddleArea 11 8 103, 617,000 Jan ADV Paul MiddleArea 14 7 103,089,000 Jan BD-CMT8 Anna SouthArea 9 2 19,800,000 Jan BD-CMT8 Lionel SouthArea 3 2 29,333,000 Jan BD-CMT8 Paredas SouthArea 1 700,000 Jan BD-CMT8 Morgan SouthArea 1 1 21,400,000 Jan HCM_NK2 Kitamura NorthArea 13 20 199,950,000 Jan HCM_NK2 Ronald NorthArea 11 13 192,158,000 Jan HCM_NK2 Mackinsey NorthArea 12 8 70,200,000 Jan HCM_NK2 Alex NorthArea 4 3 44,450,000 Jan HCM_NK2 David NorthArea 1 7,100,000 Jan HCM_NK2 Arriel NorthArea 1 7,100,000 Jan HCM_NK2 Cole NorthArea 1 7,100,000 Jan 1.Bonus for new student enroll Condition 1 Apply for Area code MiddeArea and NorthArea Condition 2 % Act vs Target of Campus is greater than and equal 80% Condition 3 # of New Student PD is greater than and equal 5 Group Group 1 Group 2 Group 3 Group 4 Group 5 Number of new Student PD 5-10 11-15 16 - 20 21 - 25 >26 Bonus 50,000 100,000 200,000 300,000 500,000 Bonus 1 =Number of New Student PD x Bonus of group Example 1 : Employee A has 32 new students enrolled Number of Student Bonus Total 10 50,000 500,000 15 100,000 1,500,000 7 200,000 1,400,000 32 3,400,000 Example 2 : Employee B has 90 new students enrolled Number of Student Bonus Total 10 50,000 500,000 15 100,000 1,500,000 20 200,000 4,000,000 25 300,000 7,500,000 20 500,000 10,000,000 90 23,500,000 Jame belong to Campus ADV which Area Code is MiddeArea and % Act vs Target 161% and # of New Student PD is 30. All of 3 conditions are satisfied. Bonus for Jame Number of Student Bonus Total 10 50,000 500,000 15 100,000 1,500,000 5 200,000 1,000,000 30 3,000,000 Bonus 1 of Jame : 3,000,000 2.Bonus according to revenue Condition 1 Apply for Area code MiddeArea and NorthArea Condition 2 % Act vs Target of Campus is greater than and equal 80% Condition 3 New Revenue PD is greater than and equal 50,000,000 Group Group 1 Group 2 Group 3 Group 4 Group 5 New Revenue PD 50,000,000-100,000,000 100,000,000-250,000,000 250,000,000-350,000,000 350,000,000 - 500,000,000 >500,000,000 Bonus 0.50% 2.50% 5% 7.50% 10% Bonus 2 = New Revenue PD x Bonus of group Example : Employee C has 20 new students enrolled with tuition revenue of 425,000,000 New Revenue PD Bonus Total 100,000,000 0.50% 500,000 250,000,000 2.50% 6,250,000 75,000,000 5% 3,750,000 425,000,000 10,500,000 In this table, Jame belong to Campus ADV which Area Code is MiddeArea and % Act vs Target 161% and New Revenue PD is 318,159,000. All of 3 conditions are satisfied. New Revenue PD Bonus Total 100,000,000 0.50% 500,000 218,159,000 2.50% 5,453,975 318,159,000 5,953,975 Bonus 2 of jame : 5,953,975 Total Bonus = Bonus 1 + Bonus 2 Bonus of Jame = 8,953,975 I post this data in this link : https://docs.google.com/spreadsheets/d/1oa_1YAC9osMY5jTjtzya-rVtsaJBe-BR/edit?usp=share_link&ouid=113792899563703127423&rtpof=true&sd=true Please help me to find the measure for calculating this bonus . Thank you so much !
Solved
sakuragihana
3 years ago Place DAX Commands and Tips
1.8KViews
0likes
6Comments
Replace the value Based other column particular market
I have the table name called Global POL. this table have three column . i am trying to replace the packtype value for particular market UA04 .this market vakue trying to set null value value. when i use replace value its changed for the all market Market packtype UA04 SOFTPACK UA04 REMARK CA04 SOFTPACK CA04 REMARK MA04 SOFTPACK MA04 REMARK Expected Output: UA04 UA04 CA04 SOFTPACK CA04 REMARK MA04 SOFTPACK MA04 REMARK Looking for support . thanks in advance .
Anonymous
3 years ago Place DAX Commands and Tips
528Views
0likes
2Comments
default Slicer
We have 4 years of data i.e from the past three years and a year of future data. we need to add a slider slicer to the date field. The slicer should be selected default for the current month (MTD) is this possible by not adding an additional column in the calendar table?
AzaharoddinSk
3 years ago Place DAX Commands and Tips
869Views
0likes
3Comments
FISCAL QUARTER WEEK CALCULATIONS - CONFUSED
Hi guys, I developed a calculated column to group dates within a Fiscal Quarter into their respective Week Groupings within the fiscal quarter. The measure works perfectly for FQ1,FQ2,FQ3 but not for FQ4 which I believe is because the calculation is confused by my fiscal periods ( Fiscal Year Begins in Feb) Here is my measure : VAR Q = 'DATE'[FiscalQuarter] VAR Y = 'DATE'[FiscalYear] VAR FYMONTH = 'DATE'[FiscalMonthNum] VAR MONTH1 = FORMAT('DATE'[Date],"MMM") VAR WEEKNUM1 = RANKX(FILTER('DATE','DATE'[FiscalQuarter] = Q && 'DATE'[FiscalYear] = Y ), WEEKNUM('DATE'[Date],2),,ASC,Dense) VAR WEEKNUMBERS = IF('DATE'[QUARTER START DAY] <> "Mon" && WEEKNUM1 = 1,1,IF('DATE'[QUARTER START DAY] <> "Mon",WEEKNUM1-1,WEEKNUM1)) RETURN WEEKNUM1 Here are my skewed reuslts for Q4 : As you can see FQ4 should begin in November but the weeks start ascending in January, then November and finally December but the tru order should be November, December and then January. Any idea how to fix my formula to take into account my fiscal period?
Solved
cdawidow2
4 years ago Place DAX Commands and Tips
594Views
0likes
1Comment
SLA MET AND NOT MET:
Hi Team, Please help me to calculate Dax for SLA load Met/Not (window hours is 6 hours for all) Calculated Load sla time as below which is working fine but unable to calculate met and not met from it. LoadSLATime = datediff(MAX('Completeness Data Pipeline Execution Details'[NIFI Start Time]), max('Completeness Data Pipeline Execution Details'[Data Pipeline End]), minute)/60 SLA Load MET = IF('Completeness Data Pipeline Execution Details'[LoadSLATime]<='Table Master'[Data Load Window Hours], TRUE(),FALSE()) Sla load met is not working correctly ,please find the yellow highliter :
Anonymous
4 years ago Place DAX Commands and Tips
2.8KViews
0likes
9Comments
CONFUSED WITH USING CONTAINS, CONTAINSSTRING NEED HELP!
Hi guys, all I want to do is simply count all sales orders that contains at least 1 of the products for a selected order. My forumla is shown below. Essentially just confused on how to use contains or containsstring to essentially search for shared values. Any help would be appreciated !
Solved
cdawidow2
4 years ago Place DAX Commands and Tips
1.5KViews
0likes
4Comments
Challenge ?
Hi All, I have the following sales table where I need to find annual ranking of salesperson. There is a small complication.... The ranking depends not only on number of annual car sales by the sales person but also takes into account how long the employee has been with the company. Shorter employment period is ranked higher. E.g. Sale of 70 cars for sonita will be ranked higher than sale of 70 cars by ravita as sonita has been with the company since only 2019, and still sold the same # of cars as ravita who has much greater experience.. Not sure how to write this in DAX to get a ranking system...?? EMPLOYEE_ID FIRST_NAME Annual Car Sales Date of Joining Annual Ranking 100 vinita 110 1-Jan-05 110 sonita 70 12-Jun-19 120 ravita 70 19-Apr-04 130 sarita 50 1-Mar-08 140 minita 95 12-Feb-20 150 binita 30 2-Oct-14 160 lonita 45 16-Sep-11 170 robita 65 11-Oct-09 180 papita 27 4-May-18 190 tomita 20 23-Dec-20
Solved
Anonymous
5 years ago Place DAX Commands and Tips
1.6KViews
0likes
1Comment