VIEW
Points
Time
Detail
+5
-
Contributed a helpful post to the data from CSV files as columns thread in the Power Query Forum.
+5
-
Contributed a helpful post to the Is Patient visit us in last 7 days? thread in the Power Query Forum.
+15
-
Answered the question Line up data into rows confirmed by the asker in the Excel for Developers Forum.
+5
-
Contributed a helpful post to the Line up data into rows thread in the Excel for Developers Forum.
0
-
Replied to a forums thread Powerpivot Equivalent for Excel SUMIFS Where Lookup Field Contains Partial Text from Another Field in the Excel for Developers Forum.
0
-
Replied to a forums thread Merge and Stack Multiple Sets of Columns dynamically | Power Query in the Power Query Forum.
+15
-
Quickly answered the question Excel 2016 Power Query can find the right rows using equal to advanced filter, but not filter them out using not equal to in the Power Query Forum.
+15
-
Quickly answered the question Group columns under a header column and summarize rows in the Power Query Forum.
+10
-
Answered the question Transform Data - using Transpose, Pivot and Unpivot in the Power Query Forum.
0
-
Contributed a proposed answer to the question Excel 2016 Power Query can find the right rows using equal to advanced filter, but not filter them out using not equal to in the Power Query Forum.
0
-
Replied to a forums thread Excel 2016 Power Query can find the right rows using equal to advanced filter, but not filter them out using not equal to in the Power Query Forum.
+15
-
Answered the question How to convert row names as column header? confirmed by the asker in the Power Query Forum.
+5
-
Contributed a helpful post to the How to convert row names as column header? thread in the Power Query Forum.
0
-
Contributed a proposed answer to the question Create a measure to return latest value in the Power Query Forum.
0
-
Contributed a proposed answer to the question Transform Data - using Transpose, Pivot and Unpivot in the Power Query Forum.
+10
-
Answered the question sum of calculated measures as a different measures in the Power Query Forum.
+10
-
Answered the question Filter Rows to Keep Dates 1 Year Older than Today and Null value in the Power Query Forum.
+10
-
Answered the question Dynamically assignment for time booking codes to resources in the Power Query Forum.
0
-
Replied to a forums thread Transform Data - using Transpose, Pivot and Unpivot in the Power Query Forum.
0
-
Contributed a proposed answer to the question Filter Rows to Keep Dates 1 Year Older than Today and Null value in the Power Query Forum.
0
-
Contributed a proposed answer to the question sum of calculated measures as a different measures in the Power Query Forum.
0
-
Replied to a forums thread Filter Rows to Keep Dates 1 Year Older than Today and Null value in the Power Query Forum.
0
-
Replied to a forums thread sum of calculated measures as a different measures in the Power Query Forum.
0
-
Replied to a forums thread DAX - Count of rows in summarized table fulfilling condition on measure with time intelligence in the Power Query Forum.
0
-
Replied to a forums thread sum of calculated measures as a different measures in the Power Query Forum.
0
-
Contributed a proposed answer to the question calculate efficiency in power pivot in the Power Query Forum.
0
-
Contributed a proposed answer to the question Group columns under a header column and summarize rows in the Power Query Forum.
0
-
Contributed a proposed answer to the question Unabelt to create Create Radar Chart in the Power Query Forum.
+10
-
Answered the question How can I get Todays date as 7/24/2020 00:00:00 in the Power Query Forum.
0
-
Replied to a forums thread Group columns under a header column and summarize rows in the Power Query Forum.
0
-
Contributed a proposed answer to the question How can I get Todays date as 7/24/2020 00:00:00 in the Power Query Forum.
0
-
Contributed a proposed answer to the question Calculating working hours without weekends in the Power Query Forum.
0
-
Replied to a forums thread How can I get Todays date as 7/24/2020 00:00:00 in the Power Query Forum.
0
-
Replied to a forums thread excel 2016 -- add calculation to pivot table dividing one column by another, or one VALUE by another in the Excel for Developers Forum.
0
-
Replied to a forums thread Find matching data between 2 excel spreadsheets in the Excel for Developers Forum.
0
-
Replied to a forums thread Parameter input as column header and compare its value in the Power Query Forum.
+10
-
Answered the question Sum of values in one query based on filter from another Query in the Power Query Forum.
0
-
Contributed a proposed answer to the question How to allow text in date data type in the Power Query Forum.
0
-
Contributed a proposed answer to the question Dynamically assignment for time booking codes to resources in the Power Query Forum.
0
-
Contributed a proposed answer to the question Pivot table averages are incorrect in the Excel IT Pro Discussions Forum.
0
-
Replied to a forums thread Pivot table averages are incorrect in the Excel IT Pro Discussions Forum.
+5
-
Contributed a helpful post to the Transforming column data containing both text and numbers thread in the Power Query Forum.
0
-
Replied to a forums thread Transforming column data containing both text and numbers in the Power Query Forum.
+20
-
Quickly answered the question Transforming column data containing both text and numbers confirmed by the asker in the Power Query Forum.
+5
-
Contributed a helpful post to the Transforming column data containing both text and numbers thread in the Power Query Forum.
0
-
Replied to a forums thread Transforming column data containing both text and numbers in the Power Query Forum.
+5
-
Contributed a helpful post to the Power Pivot doesn't regonize sources any longer thread in the Power Pivot Forum.
0
-
Replied to a forums thread Power Pivot doesn't regonize sources any longer in the Power Pivot Forum.
+15
-
Answered the question Price look up based on time confirmed by the asker in the Power Query Forum.
0
-
Replied to a forums thread Get row of the largest row based on consecutive values in the Excel for Developers Forum.
0
-
Contributed a proposed answer to the question Sum of values in one query based on filter from another Query in the Power Query Forum.
0
-
Replied to a forums thread Sum of values in one query based on filter from another Query in the Power Query Forum.
+15
-
Quickly answered the question Transpose single column to multiple columns based on another column value in the Power Query Forum.
0
-
Replied to a forums thread Dynamically assignment for time booking codes to resources in the Power Query Forum.
0
-
Replied to a forums thread power query replace values greater than 5 in the Excel IT Pro Discussions Forum.
0
-
Replied to a forums thread Calculating Variances (Value and Percent) in Pivot (not using power pivot) - is it possible? in the Excel IT Pro Discussions Forum.
0
-
Contributed a proposed answer to the question Using two recursive queries to make a one-to-many table from a many-to-many table. in the Power Query Forum.
+15
-
Answered the question average last six months confirmed by the asker in the Excel IT Pro Discussions Forum.
0
-
Replied to a forums thread Updated Question Match Rows from sheet1 to Sheet2 in the Excel for Developers Forum.
0
-
Replied to a forums thread Using two recursive queries to make a one-to-many table from a many-to-many table. in the Power Query Forum.
0
-
Replied to a forums thread dax table expression addcolumns - row - summarize - calculate with filter in ?? in the Power Pivot Forum.
0
-
Replied to a forums thread dates won't sort in my PivotTable because excel believes they are text in the Power Pivot Forum.
0
-
Replied to a forums thread Transpose single column to multiple columns based on another column value in the Power Query Forum.
0
-
Replied to a forums thread Standard deviation of sum per month in PowerPivot Excel in the Power Pivot Forum.
0
-
Replied to a forums thread Standard deviation of sum per month in PowerPivot Excel in the Power Pivot Forum.
+15
-
Answered the question Standard deviation of sum per month in PowerPivot Excel confirmed by the asker in the Power Pivot Forum.