Power Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only picking up 4 decimal places, even if the Query is formatting the data is Decimal Number (Changed Type). When the data is formatted as Number, Power Query is able to pick up all decimal places (Some numbers have 10+ decimals) Is this normal behavior? I would like to use the Accounting format because it looks cleaner, but obviously I cannot sacrifice data accuracy. It is also very illogical to have a format labeled "Accounting" only hold 4 decimal places when passed through Power Query I did try restarting Excel multiple times, refreshing queries, the only thing that resolved it was changing the local format to Number.
Drill through issue for the visual for a field that is included in fields other than X-axis
Hi Team, I have the below line chart in the device page: i want to drillthrough this line chart to a target page called device history that contains the below table: I don't want to drag the Name column from the HeatSense_Catalog table into the X-axis of line chart as thats not requirement. But it is fine if we can use that Name column in other fields like tooltip or y-axis etc. Due to this, i can't find any drill through option in the current line chart visual when i right click any data point. My expected output will contain, a drill through page with only single selected Device name,site name for different Updatedon datetime. Could you please help me resolve this issue? PFA file here PR0442 - Heatsense Live_V1_copy1.pbix tabs: Device and Device history SergeiBaklan
Userforms in Excel to generate custom Email Templates for outlook
I have a company and vendor contact list that I would like to have a userform the you select which type of email you want to create with sub sets: such as RFP, PO Request. For RFP there would be different email templates based on which service/material you are selecting and then each of those would have multiple different vendors that would each need there own separate email, just with the same body and subject line. I would also like the subject line to be variable input in the form. -Ideally the user form would have either a list or drop down that say RFP or PO Request -After that selection is made If its RFP I would like it to have an option to choose which services/materials this would pick what the body of the email would be -the user would input the Project name/ subject line -then select the vendors you want the rfp to go to and have it generate emails for all of those people would generate after a button is hit. the service and material and vendors would all be selectable from the workbook. Also, the vendors have multiple emails for each vendor but each vendor only needs 1 email template but all email address for that company need to be on the email I would also like all emails to have a CC'd person, will be the same person every time
"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THIS
Converting Task list to visual calendar
Hi! I am trying to find a way to translate the tasks to a separate Excel spreadsheet with the monthly calendar so that I can view the various project task datelines in a consolidated view. Would be best to be able to show the Project - Tasks (filter tabs in Proj Dashboard file) on the proj calendar... Any help will be appreciated! Thanks~ Link to the files below Project Dashboard Proj CalendarUrgent for geography Coursework help (due tonight)
I compared 2 different areas using a visual housing survey and used 4 different categories - including exterior appearance, noise level, cleanliness and house plot size - I want to use statistical test to help my conclusion but i don't know which one and howIngredients calculator
Good Morning, hoping someone can help. I want to creat a formula which works out if I need to make 1 pizza it then can work out the sum of how much cheese I will need. so if I need 70grams of cheese per pizza and I enter on my sheet that I will make 10 pizza it will then make the calculation of how much cheese I will need for 10 pizza’s obviously I can then scale this to work with other toppings. Ideally I’m looking for the end figure to be in grams but could also be in KG if that’s easier. Any help would be incredible. Many thanks!
Pushing Updates to Multiple Excel Files That have The same Layout
I am the owner of file used by Mutiple locations throughout the US that all have the same exact same layout but have different data connections to each of the individual locations. When an update is requested, it becomes a very cumbersome task to update all of the files. I hoping someone has dealt with a similar situation before and was hoping there is a way to "publish" updates and then push them to all of the workbooks. Maybe make a change to a master copy and run a script to update the rest. Thank you all in advance!
