DAX formula to repeat text series in a column
Hello guys, I wonder if there would be a DAX formula for a conditional column where these 3 items are repeated continuously: Distributor Wholesale Retail Then the loop continues again with these same values from distributor to retail and on and on as long as a value exists in the cells of another column that I specify.
Reg a conditional column
Hi , I need to calculate the sum of efforts spend on each task for particular month , i have a column in my excel sheet as Actual hours and Actual hours1 ,Actual hours2. For example , If the task is started on January month and ended in Febrauary month ,then the Actual efforts are splitted as Actual hour1 for january and Actual hour2 for February. So if i need to calculate the January month effort it should calculate as Actual Hour (Jan)+ Actual Hour 1. That is 104 hours for January For February its should be Actual hour ( Feb )+ Actual Hour2 =44 Could ypu please help to insert a conditional column as above to create the dash boardHow to create condition column based on quick measure
Hello Power BI community, I am struglling with one scenario where I have quick measure which subtracts two columns from two diffrent tables. Based on which i want to have one more column with result if 'quick measure (DIFF)' ='0' then its 'yes' or else if less than or greter than zero it should be false. The relationship between both the tables are based on Sr.No = 'Many to Many' as One to One is not possible to be created. Here is the example two data set: DataSet_FDBA Sr No FDBA 1 100 2 1500 3 1500 4 200 DataSet_ TBA Sr No TDBA Quick Measure (DIFF) Required column 1 90 10 No 2 1500 0 Yes 3 1400 100 No 4 200 0 Yes Can anyone guide me how can i achieve the required column. I am open for suggestions to redesign in order to achieve difference column and conditional yes or No column. Thank you in advance. Regards, Hemant
Comparing dates in the maximum Selected date with the column of the table via If and Else statement
I am trying to compare the dates in the maximum Selected date with the column of the table via If and Else statement and it is not working as expected. It seems like somehow it is not recognizing the measure as dates. My Measure to have the maximum date selected: MaxPostDateSelected = CALCULATE(MAX((PostDate[Date])),ALLSELECTED(PostDate[Date])) If and else statement for the table Maint with the Post_date as the column: PostDateCheck = if(Maint[Post_Date]>=[MaxPostDateSelected],"YES","NO") The formula runs but it is not working as expected.
