User Profile
ChrisMendoza
Iron Contributor
Joined Mar 19, 2019
User Widgets
Recent Discussions
Re: CONCAT Function Not Working
Jean_G-10 - are you getting a #VALUE error? I would suggest you 'Evaluate Formula' in the Formulas Ribbon to find where the function fails. As an example, not having a space in the text string during the LEFT(MID(... part will cause a failure on your FIND( ... Other than that, you'll need to provide a sample of the failing text string and one that is working correctly.Re: CONCAT Function Not Working
tencat951- take a look at HansVogelaar response HansVogelaar wrote: As mentioned in other replies in this discussion: Make sure that the cell with the formula is not formatted as Text. Make sure that the Show Formulas button in the Formula Auditing group of the Formulas tab of the ribbon is not highlighted.Re: Multiple team survey with Forms and different managers?
Amitabh540- Create the Form from within Excel Online and share that (dynamic) file with your managers. Create your own dashboard in Excel. If you create the form in Forms you will get a static file you will need to manually download or you could create a Power Automate trigger on submit to write to Excel/SharePoint/Etc.Re: Extracting content from all cell notes on Excel sheet
EloyMendoza- it looks like https://professor-excel.com/excel-extract-comments-text-to-cell/ was updated for threaded comments. I have this version of Excel now so I can't test on an older version. My guess however is that you'll need to refresh the formula manually (enter edit mode and then enter; or similar manually) or I suppose you could do some VBA on cell change to refresh the calculation.Re: No notification email to assignee when get new tasks or task is completed
GaryZhao- If you've set the Plan settings > Notifications at tasks.office.com and you're still not receiving notifications how you would like then you'll likely need to create your own notifications using Power Automate. Another reason you might want to use Power Automate is for 'guest' tasks as they do not seem to get notified either. Personally, instead of sending an email I choose to send a Teams message but that is also because I try to stay within Teams.Re: Download All Tasks in All Plans
ccarlso2- I would tend to worry about the https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations#request-limits-based-on-user-licenses (each action is a request ['each group' x 'each plan' x 'each task'] will add up quickly) and possibly a timeout on the Flow. However, this is totally doable within Power Automate. Basically you would need to use: https://docs.microsoft.com/en-us/connectors/office365groups/#list-groups-that-i-own-and-belong-to which will return 'Group ID' https://docs.microsoft.com/en-us/connectors/planner/#list-plans-for-a-group which will return 'Title' and 'ID' of the Plan https://docs.microsoft.com/en-us/connectors/planner/#list-tasks which will return task information Essentially, you're creating a nested 'Apply_to_each' like below: which results in:Re: Powerpivot calculations
Oraclein - I think in all of the DAX patterns I have seen involving Budget vs. Actual's the values have been in separate tables. In your example, I only see a normal Pivot Table with a your months cross tabulated and nothing in the Data Model. I think you will find it difficult to visually represent Net Sales, COGS, Gross Margin in your desired row context as those calculations are created in measures. Possibly the simple example I have created will work for your needs but if not, take a look at https://www.daxpatterns.com/budget-patterns/ and https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Re: How to number each occurrence of a substring in a cell in Power Query?
DGuzmanG - Will this work for you? let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKijKTylNLtHNS8xN1csqSFfSUTJWitWJVsovyUgt0oVKQ2VMlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"Image Base Name" = _t, ImageQty = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Image Base Name", type text}, {"ImageQty", Int64.Type}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Transform({1 ..Number.From([ImageQty])}, each Number.From(_))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"), #"Added Custom1" = Table.AddColumn(#"Expanded Custom", "Custom.1", each Text.Insert([Image Base Name],Text.PositionOf([Image Base Name],".",Occurrence.Last),"-"&Text.From([Custom]))), #"Grouped Rows" = Table.Group(#"Added Custom1", {"Image Base Name", "ImageQty"}, {{"Data", each _, type table [Image Base Name=text, ImageQty=number, Custom=number, Custom.1=text]}}), #"Added Custom2" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.Column([Data],"Custom.1")), #"Extracted Values" = Table.TransformColumns(#"Added Custom2", {"Custom", each Text.Combine(List.Transform(_, Text.From), " "), type text}), #"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"Data"}) in #"Removed Columns"
