access to bookings
What does this message mean on microsoft booking, ive been trying to see my booking registry but i keep seeing this message, sometimes the massage varies when i try to access the app : Detailed message displayed: UTC Date: 2025-03-11T14:14:30.266Z Client Id: F6F199305D9541EDA2A53EE57C90EDB8 Session Id: 8009806d-b6f3-40b9-9ddd-0ef7ba2b900f Client Version: 20250310070 BootResult: network Back Filled Errors: Unhandled Rejection: Error: [object Object]:undefined|Unhandled Rejection: Error: [object Object]:undefined|undefined:undefined|undefined:undefined err: Error: [object Object] esrc: StartupData et: ServerError estack: Error: [object Object] at https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.47106.6187e72c.js:1:71227 at async S (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:3108) at async https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.10245.3a6876a0.js:1:2460 at async l (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:97492) at async w (https://res.df.onecdn.static.microsoft/owamail/hashed-v1/scripts/owa.bookingsindexv2.b6602698.js:1:100345)
Issue in Days Function
Hello there, I am Balaji, I hope you are all doing well. I am using Windows 10 in Dell Latitude 7480 Laptop. I am facing an issue using the "Days" Function. DAYS Function Explanation and Description mentioned in Excel Software: DAYS FUNCTION This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY Function. Description: Returns the number of days between two dates. DAY function This article describes the formula syntax and usage of the DAY function in Microsoft Excel. For information about the DAYS function, see DAYS Function. Description: Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Now, If I am using the "DAYS" Function to calculate the number of days between two dates. Suggest me Which Function should I use to get the correct answer. I am Looking forward to your guidance. Thank you.
KPI dax logic not giving correct counts but table visual does
Hi Team, I have below dax for the Doors open kpi: Doors Open = VAR _count = CALCULATE( MAX( BMSDoorStoreJoin[CreatedOn] ), BMSDoorStoreJoin[Status] = "Open" ) VAR _siteid = MAX(BMSDoorStoreJoin[SiteId]) RETURN CALCULATE( COUNT( BMSDoorStoreJoin[CreatedOn] ), BMSDoorStoreJoin[Status] = "Open"&& BMSDoorStoreJoin[CreatedOn] = _count && BMSDoorStoreJoin[SiteId] = _siteid ) Now, this returns the value of 1 which is wrong according to filtered SiteId(StoreName). My expected output from this logic is I want to find unique count of Doors Open(Site[Sitecode]) for the max of createdon date. For example, the data below for Sitecode 472 we have Status as closed and we don't have open. So it should retun nil. but in this case it returns 1. My table visual also shows correctly that it has only closed status. When i use my kpi logic in that visual it gives correct count. Please advise! PFA file here BMS Chillers Insights.pbix Thanks in advance! SergeiBaklanFilter context playing up with Calculated column logic in report visual
Hi Sir, I have a calculated column as below: Its working fine in this table level. But when I use this column in a table visual in report its not working correctly and its giving 'Yes' in all rows of the table for same deviceid: FYR, screenshot attached: It should contain only rows where there are warnings(Yes). But when i remove the OpenMinutes,Storetime and Door Time from above table, I get the correct output: My expected output for filtered sitecode 73 and deviceid 2452 is i need below columns along with Store Time, Door Time and OpenMinutes(openstateduration table): Store Time comes from Openstateduration table DateTimeRounded which is linked to Door table DateTimeRounded(Both date columns should match): Door Time will be coming from Createdon date of Openstateduration table which is linked to Door table Createdon(Both date columns should match): Modeling for these tables are: Could you please help me fix this issue? Also, much appreciated if you help me with alternative or better solution like pushing Warning logic to power query or creating better modeling for this issue etc. PFA file here B&M (4).pbix Please feel free to let me know if any issues! Thanks in advance! SergeiBaklanLong numbers handling problem
Hi. I have a shop with 6600 articles. Some has long article numbers that come from our supplier - so I can't modify them. Why I can't use it even if I set a custom format with 20xzero (00000000000000000000). Examples: good article number: 15977048001200040000 Excel change it to: 15977048001200000000 It delete the 4 if you check the end of the article number second example: 106010100006500001562 106010100006500000000 It looks like the excel change the last some digits to zero... I made a test with this 20 digit: 12345678901234567899 12345678901234500000 It definitely delete the last 5 digit ans change to zero. why??? Thanks PeterCreating Logic to find whether columns in one table matches other columns in other table
Hi Team, I have 2 tables: Door table as below: Store Status table as below: They are modelled as below (let me know if we can better model it-suggestions are welcomed): Now, I need to create a logic(Breach) to find when Door Table - Status column being Open when Store Status table - Status column being Closed (indicated by - 'C'). During this logic, we have to make sure it satisfies below conditions: DateTime column of Store Status table should match the createdon column of Door table Store id column of Store Status table should match the siteid of Door table Output should return 1 if the conditions meets else 0. Could you please help me create a logic for this? PFA file here B&M.pbix Thanks in advance! SergeiBaklan
Formatting a clustered column chart
Trying to get the text at the bottom of the graph to align with the bars. Can someone please tell me how I can format it so that the text at the bottom aligns with the bars? I have tried everything and cannot work out what I have done wrong. TIA for any advice/assistance
