User Profile
ankurbajaj07
Helper I
Joined 3 years ago
User Widgets
Contributions
Re: Summing up of manhours based on slicer range selection corresponding to filtered jobs
Its the same as option 2 which i tried but is not filtering manhours based on seletcion. When i am using this measure in table along with jobs, only job are getting filtered in line with slcier and then manhours are getting summed up against that job for all instances of the job removing the slicer criteria.1.2KViews0likes0CommentsRe: Summing of manhours based on slicer calender range selection for the filtered jobs
Its the same as option 2 which i tried but is not filtering manhours based on seletcion. When i am using this measure in table along with jobs, only job are getting filtered in line with slcier and then manhours are getting summed up against that job for all instances of the job removing the slicer criteria.687Views0likes0CommentsSumming of manhours based on slicer calender range selection for the filtered jobs
In power bi, I need a measure for dax code where when user selects date range from a slicer (calender table), jobs (only the instances where it lies in the selected calender date range) and corresponding manhours (only for the selected calender date range) from my table Bi_ alloceffort_data gets displayed where the REVDATE in same table falls between the user selected range. I tried the follwomg codes: 1. Selected_Manhours := VAR SelectedMinDate = MIN('Calendar'[Date]) VAR SelectedMaxDate = MAX('Calendar'[Date]) RETURN CALCULATE( SUM(Bi_alloceffort_data[Manhours]), Bi_alloceffort_data[REVDATE] >= SelectedMinDate && Bi_alloceffort_data[REVDATE] <= SelectedMaxDate ) 2. Selected_Manhours := VAR SelectedMinDate = MIN('Calendar'[Date]) VAR SelectedMaxDate = MAX('Calendar'[Date]) RETURN SUMX( FILTER( Bi_alloceffort_data, Bi_alloceffort_data[REVDATE] >= SelectedMinDate && Bi_alloceffort_data[REVDATE] <= SelectedMaxDate ), Bi_alloceffort_data[Manhours] ) 3. Selected_Manhours := VAR SelectedMinDate = MIN('Calendar'[Date]) VAR SelectedMaxDate = MAX('Calendar'[Date]) RETURN CALCULATE( SUM(Bi_alloceffort_data[Manhours]), KEEPFILTERS( Bi_alloceffort_data[REVDATE] >= SelectedMinDate && Bi_alloceffort_data[REVDATE] <= SelectedMaxDate )) But all the solutions are selecting the job based on slcier filter and then summing all the manhours (even ehen they are outside the slicer range) for the all job instances. I need manhours only for the instance where jobs and manhours are within the selected slicer range. Pls helpSolved700Views0likes7CommentsSumming up of manhours based on slicer range selection corresponding to filtered jobs
In power bi, I need a measure for dax code where when user selects date range from a slicer (calender table), jobs (only the instances where it lies in the selected calender date range) and corresponding manhours (only for the selected calender date range) from my table Bi_ alloceffort_data gets displayed where the REVDATE in same table falls between the user selected range. I tried the follwomg codes: 1. Selected_Manhours := VAR SelectedMinDate = MIN('Calendar'[Date]) VAR SelectedMaxDate = MAX('Calendar'[Date]) RETURN CALCULATE( SUM(Bi_alloceffort_data[Manhours]), Bi_alloceffort_data[REVDATE] >= SelectedMinDate && Bi_alloceffort_data[REVDATE] <= SelectedMaxDate ) 2. Selected_Manhours := VAR SelectedMinDate = MIN('Calendar'[Date]) VAR SelectedMaxDate = MAX('Calendar'[Date]) RETURN SUMX( FILTER( Bi_alloceffort_data, Bi_alloceffort_data[REVDATE] >= SelectedMinDate && Bi_alloceffort_data[REVDATE] <= SelectedMaxDate ), Bi_alloceffort_data[Manhours] ) 3. Selected_Manhours := VAR SelectedMinDate = MIN('Calendar'[Date]) VAR SelectedMaxDate = MAX('Calendar'[Date]) RETURN CALCULATE( SUM(Bi_alloceffort_data[Manhours]), KEEPFILTERS( Bi_alloceffort_data[REVDATE] >= SelectedMinDate && Bi_alloceffort_data[REVDATE] <= SelectedMaxDate )) But all the solutions are selecting the job based on slcier filter and then summing all the manhours (even ehen they are outside the slicer range) for the all job instances. I need manhours only for the instance where jobs and manhours are within the selected slicer range. Pls helpSolved1.2KViews0likes7CommentsRe: Powerbi: Need column difference based on slicer selection by user
Hi , thanks for the reply. Query 2: this measure is summing up ST_CLGBAL for all the instances of job (Rev0 , Rev1...) once the job is filtered based on REVDATE lying within slicer range. i.e. it is clearing the slicer filter for summing up ST_CLGBAL once the job is selected based on slicer range. However, I need ST_CLGBAL for only that job instances which lies within the slicer range. i.e. ST_CLGBAL should be from the selected slicer range only corresponding to the job which is filtered from slicer range.729Views0likes0CommentsPowerbi: Need column difference based on slicer selection by user
I am new to Power bi. I have tables -> calender , bi_alloceffort_data & bi_alloceffort_data_main. I Have linked calender date column to REVDATE column of bi_alloceffort_data & "PROJECTNO" of both the tables. I have created a timeline slicer from the calender table. I have two queries: In slicer visual -> Format-> fiscal year, I selected April as the fiscal year. But the slicer shows 20-Oct-2019 as 2020 Q3 instead of 2019 Q3. Need to get it correct. 2.When user select a date range from the slicer, I need "ST_CLGBAL" -"ST_PREVCLGBAL" (from table bi_alloceffort_data) for the "JOBNO" where "REVDATE" lies in the user selected date range from the slicer. pbix saved at below link . https://drive.google.com/file/d/13Odb7e5_m2PBl4OqLX9QxLmZ1o2uB2Bc/view?usp=drive_link Pls guide.Solved797Views0likes8CommentsRe: Need two filters to be applied on visual matrix table having date distribution
Sorry for that. access granted to below link for sample pbix https://drive.google.com/drive/folders/1FDg8c1Cy_VsEo14Bgc6b9TKOpyZi1S9u?usp=share_link Also, I tried this code Last3MonthsAndLastFYMarDataDistribution = VAR CurrentDate = TODAY() VAR Last3MonthsStartDate = DATEADD(MAX('Main Data table'[Date]), -2, MONTH) VAR Last3MonthsEndDate = MAX('Main Data table'[Date]) VAR CurrentYear = YEAR(TODAY()) VAR LastFiscalYear = IF(MONTH(TODAY()) > 3, CurrentYear, CurrentYear - 1) VAR LastFYMarStartDate = DATE(LastFiscalYear - 1, 4, 1) VAR LastFYMarEndDate = DATE(LastFiscalYear, 3, 31) RETURN CALCULATE( SUM('Main Data table'[Date]), FILTER( 'Main Data table', 'Main Data table'[Date] >= Last3MonthsStartDate && 'Main Data table'[Date] <= Last3MonthsEndDate || 'Main Data table'[Date] >= LastFYMarStartDate && 'Main Data table'[Date] <= LastFYMarEndDate ) ) Will it work? actually i am facing one error -> The first argument to 'DATEADD' must specify a column. i am not understanding the error , so can you help me with the error and can check and confirm whether this will work?1.8KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.