I have a user who continues to receive this AADSTS70008 error in Outlook Desktop.  This computer has been in service for several years and Outlook desktop has been running fine.  User can successfully authenticate in MS Teams and Outlook on the Web. MFA is enabled.  I have attempted a restart but Outlook produces the same error.  I have seen older posts suggesting that the registry key for the office activation be removed to fix this issue.   Any thoughts on a more straightforward fix than registry hacks?

DSTS70008

​I have a user who continues to receive this AADSTS70008 error in Outlook Desktop.  This computer has been in service for several years and Outlook desktop has been running fine.  User can successfully authenticate in MS Teams and Outlook on the Web. MFA is enabled.  I have attempted a restart but Outlook produces the same error.  I have seen older posts suggesting that the registry key for the office activation be removed to fix this issue.   Any thoughts on a more straightforward fix than registry hacks? DSTS70008  Read More

​

Microsoft is pleased to share that we will release a refreshed HLK for Windows 11 24H2 and Windows Server 2025 to in October.  

This release of the HLK will contain fixes for test Errata which will help keep the overall test quality high while helping reduce triage time for known test issues. The refreshed version of the HLK will replace the RTM version that is available on the HLK download site. Partners can submit to WHCP using either the RTM version of the HLK for Windows 11, version 24H2 and Windows Server 2025 or the refreshed HLK so long as passing results can be obtained (waivers acceptable).

Errata that are fixed in the refreshed version are expected to be expired 90 days after the release of the refreshed HLK. As we transition into this servicing model, which maintains overall test quality and reduces dependency on errata, we acknowledge that the refreshed HLK may not address all scenarios. If any errata remain relevant after using the refreshed HLK, please contact CSS for assistance. For more details, please review the Frequently Asked Questions.

Frequently Asked Questions

What HLK version is being refreshed?

The HLK released in May 2024 to support certifying drivers for Windows 11, version 24H2 and Windows Server 2025. For the following FAQ’s, the May 2024 release will be referenced to as RTM HLK and the upcoming release in October will be referenced as Refresh HLK.

How can I tell what version of the HLK I have?

The distinction between RTM HLK and Refreshed HLK will be in the last digits of the HLK studio version, 10.1.26100.X

The RTM HLK Studio version is 10.1.26100.1
The Refresh HLK Studio version is 10.1.26100.X

The HLK Studio version information can be located by clicking ‘About’ in the upper right corner of studio

How do I install the Refreshed version of the HLK?

Visit the HLK download page: Windows Hardware Lab Kit | Microsoft Learn
Download the Refreshed HLK
Run HLKSetup.exe

Notes

Ensure your current HLK projects are finished before attempting to use the same system for the HLK Refresh.
The Refreshed HLK cannot be installed on a system that already has the RTM HLK, this goes for both Controller and Client. It is highly recommended to start with a clean install of the OS for both.

How can I tell if the Errata I use was fixed in the Refreshed HLK?

The list of Errata fixed is available below

What do I do if the Errata I use doesn’t appear to be fixed in the Refreshed HLK?

If the Errata is not on the fixed list the waiver can be used on both the RTM HLK as well as the Refreshed HLK

What do I do if the Errata I use is listed as fixed, but failures are still being seen in the test?

Triage the failure first, there have been cases where a test issue is fixed, and the failure is still present but its due to a driver issue that has the same failure message
Next Open a CSS case: Get support for Partner Center dashboard and HLK issues – Windows drivers | Microsoft Learn

How should I address a test that was passing on the RTM HLK but now failing on the refreshed HLK?

Triage the failure first, there have been cases where a test issue is fixed, and the failure is still present but its due to a driver issue that has the same failure message
Next Open a CSS case: Get support for Partner Center dashboard and HLK issues – Windows drivers | Microsoft Learn

Going forward, will Microsoft be updating the HLK regularly?

Yes, Microsoft is transitioning into this servicing model for the HLK, which maintains overall test quality and reduces dependency on errata.

How often are these refresh releases expected?​

Current plan is to evaluate releasing a refreshed HLK each quarter. ​

Does this update apply to client and server?

Yes

Can results from an RTM test run and a Refreshed test run be merged and used for submission?

No, submission must be completed with either the RTM or Refreshed HLK.

Will the refreshed HLK continue to support merged packages for multiple-OS submissions?

Yes

Is the VHLK also going to be updated?

Yes

Errata Fixed in the October 24’ Refresh

ID
Title
Job/Task Failing

91345
[HLK Errata] AudioLogo (system) enforces channel count on default mode
System Audio – Audio Logo Test

127433
[Auto-triage] New binary with endpoint stabilization delay
Audio Codec – Lullaby Test – Certification – Desktop

161095
[HLK Errata]: Voice Clarity Driver Timestamp Test requires small mic spk stream drift
Voice Clarity HLK Test Driver Timestamp

163288
[HLK Errata] Validation of UVC MJPG Translation Opt-in always fails for UVC IR Camera
Camera Driver System Test – Validation of UVC MJPG Translation Opt-in

163289
[HLK Errata] Camera Driver Registration Test IMFSampleAllocator check fails on Platform DMFT
Camera Driver Registration, Metadata, and Dependency System

164528
[HLK Errata] DF – PNP tests failure with Failed to open the EDT device (device specific)
Multiple

164532
[HLK Errata] Driver Isolation DV failures for serial.sys accessing SERIALCOMM registry key.
DV – EnumerateEvents

164702
[HLK Errata] Driver Isolation DV failures for wudfrd.sys accessing SERIALCOMM registry key.
DV – EnumerateEvents

167195
[HLK Errata] Camera Driver Registration Test IMFSampleAllocator check fails on Platform DMFT
Camera Driver Registration, Metadata, and Dependency System

167196
[HLK Errata] [Camera Driver Controls System Test – Framerate Throttle – Verify Mode Switching] – Does not account for Step Sizes
Camera Driver Controls System Test – Framerate Throttle – Verify Mode Switching

167197
[HLK Errata] Sensor Camera Profiles – Photo Sequence with MEP Camera fails
Sensor Camera Driver Controls System Test – CAMERA_PROFILES – Photo Sequence

167453
[HLK Errata] Media Capture TestFrameExposureControlWithCapture uses wrong Table Entry
TestFrameExposureControlWithCapture

167494
[HLK Errata] Camera Driver Controls System Test – VFR – Verify correct Pin fails for MEP devices
Camera Driver Controls System Test – VFR – Verify correct Pin fails for MEP devices

167738
[HLK Errata] Camera Driver System Test – MediaCapture – TestInfraredTorchControlMetadata fails for filtered Legacy Profile
Camera Driver System Test – MediaCapture – TestInfraredTorchControlMetadata

167884
[HLK Errata] Camera Driver System Test – MediaCapture – ValidateExposureCompensationValues fails due to IR camera
Camera Driver System Test – MediaCapture – ValidateExposureCompensationValues

168217
Human Presence Proximity Test Failing on Non Human Presence based Proximity Sensors
Human Presence capable Proximity Sensor Enumeration Property Verification Test

168478
[HLK Errata] [NdisStudio] NDIS keyword validation tests are listed under incorrect feature, causing failures for devices not advertising NDIS
[NdisStudio] NdisPoll keyword validation
[NdisStudio] NdisPoll keyword functional validation

168710
[HLK Errata] Display Capture Tests failing for Indirect Display devices
Display capture tests

170424
[HLK Errata] Camera Driver System Test – MediaCapture – Digital Window Metadata fails for combined IR RGB Sensor Group
Camera Driver System Test – MediaCapture – Digital Window Metadata

171184
[HLK Errata] [NdisStudio] OidRequestTest – OID_GEN_XMIT_OK and OID_GEN_RCV_OK Verification test fail when link speed is less than 1Gbps
[NdisStudio] OidRequestTest – OID_GEN_XMIT_OK and OID_GEN_RCV_OK Verification

173553
[HLK Errata] Camera Driver Hardware Privacy Manual Test fails due to Kill Switch behavior
Camera Driver Hardware Privacy Manual Test

173718
[HLK Errata] NDISTest 6.5 – [2 Machine] – PM_PowerStateTransition & PM_WolMagicPacket & PM_WolPattern test fail
NDISTest 6.5 – [2 Machine] – PM_PowerStateTransition
NDISTest 6.5 – [2 Machine] – PM_WolMagicPacket
NDISTest 6.5 – [2 Machine] – PM_WolPattern

173736
[HLK Errata] Camera Driver Controls System Test – VIDEOSTABILIZATION – Iterate through possible settings while Preview fails with MEP due to Pin re-mapping
Camera Driver Controls System Test – VIDEOSTABILIZATION – Iterate through possible settings while Preview

175039
[HLK Manual Errata]: NDIS test failed due to the certificate in HLK Studio is out of date
[NdisStudio] OidRequestTest – OID_GEN_VENDOR_DRIVER_VERSION Verification
[NdisStudio] OidRequestTest – OID_GEN_VENDOR_ID Verification
[NdisStudio] OidRequestTest – OID_GEN_XMIT_OK and OID_GEN_RCV_OK Verification
[Network Adapter] Verification for network

177219
[HLK Errata] Camera Driver System Test – Mediacapture – TestEffectOptInCameraEnumeration does not check regkey value
Camera Driver System Test – Mediacapture – TestEffectOptInCameraEnumeration

177825
[ERRATUM] KS Topology Test Fails Custom Audio Modes
System Audio – KS Topology Test

179949
[HLK Errata] Camera Control Pin Verification Tests failing due to MEP Pin remapping
Sensor Camera Driver Controls System Test – * – Verify correct Pin

181916
[HLK Errata] Driver Isolation DV failures for snxpsamd.sys accessing SERIALCOMM registry key.
DV – EnumerateEvents

184662
[HLK Manual Errata]: A crash with exception code 0xC0000005 occurred when running InternalPanel – Common color profile problems test
InternalPanel – Common color profile problems

188557
AutoTriage: HLK USB Secure Camera Controller Dual BDF Test – Compat test failure.
USB Secure Camera Controller Dual BDF Test – Compat

​Microsoft Tech Community – Latest Blogs –Read More 

We are pleased to announce the security review for Microsoft Edge, version 129!

We have reviewed the new settings in Microsoft Edge version 129 and determined that there are no additional security settings that require enforcement. The Microsoft Edge version 128 security baseline continues to be our recommended configuration which can be downloaded from the Microsoft Security Compliance Toolkit.

Microsoft Edge version 129 did not introduce any new settings therefore no spreadsheet was generated for this release.

As a friendly reminder, all available settings for Microsoft Edge are documented here, and all available settings for Microsoft Edge Update are documented here.

Please continue to give us feedback through the Security Baselines Discussion site or this post.

​Microsoft Tech Community – Latest Blogs –Read More 

Aug 2024 Recap: Azure PostgreSQL Flexible Server

This month we’ve introduced:

Reserved pricing for Intel & AMD V5 SKUs
Support for the latest Postgres minor versions
New extensions like “postgres_protobuf” and “postgresql_anonymizer”
Updates to Ansible modules and DNS record management
Enhanced migration services including support for TimescaleDB
New capabilities for Burstable SKU migrations
And more!

Dive into the details and discover how these updates can improve your database management and security. Read the full blog post :link: – https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/aug-2024-recap-azure-postgresql-flexible-server/ba-p/4238812#postgres-minor-versions

​Aug 2024 Recap: Azure PostgreSQL Flexible ServerThis month we’ve introduced:

Reserved pricing for Intel & AMD V5 SKUs
Support for the latest Postgres minor versions
New extensions like “postgres_protobuf” and “postgresql_anonymizer”
Updates to Ansible modules and DNS record management
Enhanced migration services including support for TimescaleDB
New capabilities for Burstable SKU migrations
And more!

Dive into the details and discover how these updates can improve your database management and security. Read the full blog post :link: – https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/aug-2024-recap-azure-postgresql-flexible-server/ba-p/4238812#postgres-minor-versions  Read More

​

Attention Advisor,

I am currently using excel spreadsheet for costs and quotes on customers.

I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly.  For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%.  But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up.  Is anything like this a possibility? 

​Attention Advisor, I am currently using excel spreadsheet for costs and quotes on customers. I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly.  For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%.  But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up.  Is anything like this a possibility?   Read More

​

I have a peculiar issue and I wonder if anyone else has had this issue or experienced anything similar. 

At the tail end of migrating a company to Microsoft Teams voice, most of the issues have been rectified apart from two numbers. When ever we assign these numbers to a user, they cannot call out, assign a number and they work. 

Immediately think its the SIP Provider, as in other cases the number has not been ported correctly. However from the investigation it seems on the INVITE as the number leaves teams, it is incorrect. On the offending number the P-ASSERTED-IDENTITY is showing as (tel:)

The working example given shows this as a SIP Record.

The CONTACT header is different. My Carrier has assured me the number is set up correctly and it this is coming from Teams

​I have a peculiar issue and I wonder if anyone else has had this issue or experienced anything similar.  At the tail end of migrating a company to Microsoft Teams voice, most of the issues have been rectified apart from two numbers. When ever we assign these numbers to a user, they cannot call out, assign a number and they work.  Immediately think its the SIP Provider, as in other cases the number has not been ported correctly. However from the investigation it seems on the INVITE as the number leaves teams, it is incorrect. On the offending number the P-ASSERTED-IDENTITY is showing as (tel:)The working example given shows this as a SIP Record. The CONTACT header is different. My Carrier has assured me the number is set up correctly and it this is coming from Teams   Read More

​

Hi, 

After Exchange 2019 CU14 users can’t:

– Search in cached mode.

– Open other users calendar.

– Set out of office.

All of the above works perfectly in OWA.

We did install the latest hotfix that should fix the search issue but no. We have installed latest outlook and reinstalled a computer, nothing helps.

Regards

Johan

​Hi, After Exchange 2019 CU14 users can’t: – Search in cached mode.- Open other users calendar.- Set out of office. All of the above works perfectly in OWA. We did install the latest hotfix that should fix the search issue but no. We have installed latest outlook and reinstalled a computer, nothing helps. RegardsJohan  Read More

​

We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022.  We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012.  As long as we don’t change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022.

When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005…”   All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab. 

Any ideas on what we can do to get this to work on our new server?

If we add a source without a destination, it doesn’t error out.  As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn’t initiated until a destination is added. 

​We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022.  We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012.  As long as we don’t change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022. When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005…”   All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab.  Any ideas on what we can do to get this to work on our new server? If we add a source without a destination, it doesn’t error out.  As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn’t initiated until a destination is added.   Read More

​

I’m curious what you all think of this approach for managing state in excel with minimal computational impact.  I’m sure after a few thousand different items to track, performance may be implicated, but the formulas initially feel like they will create static values that don’t have to be recalculated with any frequency.  Skip towards the end if you just want to see the formulas.

I think one of the important ideas here is that this formula can be used within a table column the same as any other formula that doesn’t return an array, the difference being that calculations are not lost between steps of the row and the only information a calculation needs is the limited state info in the prior state.

Any comments welcome.  If you’ve found a better way to do this, I’d be curious to know.  I am limiting myself to using only native excel formulas/functionality plus excel labs.

P.S.  The formulas have one or two undeveloped ideas because they are not essential.  For instance, there is one inline lambda that uses a switch to return a comparison function for data masking that has only implemented the equals and does not equal operators.

**********Description********************

General idea is such – write a series of formulas that serialize and deserialize arrays and combine it with an efficient mechanism to access the most recent state.  The example uses the idea of lots of items where each lot has a quantity and cost – transactions can either increase the quantity (and cost) or decrease it.  The state being managed is the existent lots, their quantities, and their costs.

columns are simple:

control; date; lot; qty; cost; state

So here is the overall structure:

table formula checks control column to see if the current row impacts the state –

       if it doesn’t, return nothing,

       if it does, move on 

            if it is the first control number, just serialize the row data

            if it isn’t, find the prior state and update it

The way it updates the state is by

1) deserializing the prior state

2) determining whether the prior state already included the current row’s item

3) updating that value if so or just returning the current rows values,

4) filtering the prior state to remove the current row’s item

5) vstacking the filtered array onto the current row’s entry (potentially updated), and

6) serializing the current state.

Using 40 rows as an example, I might end with a serialized state that looks like this:

lot_H,65,650;lot_I,100,1000;lot_J,45,450;lot_K,70,700;lot_L,30,300;lot_A,135,1350;lot_B,150,1500;lot_C,145,1450;lot_D,90,900;lot_E,120,1200;lot_F,80,800;lot_G,170,1700

and deserializes to this:

lot_A 135 1350
lot_B 150 1500
lot_C 145 1450
lot_D 90 900
lot_E 120 1200
lot_F 80 800
lot_G 170 1700
lot_H 65 650
lot_I 100 1000
lot_J 45 450
lot_K 70 700
lot_L 30 300

using this function: SORT(array.deserialize_string(I57))

table formula:

=IF(
TRIM([@lot]) = “”,
“”,
IF(
[@control] = 1,
array.serialize_array(Table68[@[lot]:[cost]]),
LET(
current_trans, Table68[@[lot]:[cost]],
last_state_ctrl, MAX(
FILTER([control], ([control] < [@control]) * ([lot] <> “”) * (2024 <= [@date])),
1
),
last_state, XLOOKUP(last_state_ctrl, [control], [state], “”, 0),
array.serialize_array(array.track_state(array.deserialize_string(last_state), current_trans))
)
)
)

module formulas:

deserialize_string = LAMBDA(state_string, TEXTSPLIT(state_string, “,”, “;”, FALSE));
serialize_row = LAMBDA(row, TEXTJOIN(“,”, FALSE, row));
serialize_array = LAMBDA(state_array,
REDUCE(
,
BYROW(state_array, LAMBDA(r, serialize_row(r))),
LAMBDA(acc, current_row, acc & “;” & current_row)
)
);

serialized_wrapper = lambda(state_string, func_to_apply, serialize_array(func_to_apply(deserialize_string(state_string))));

replace_row =
lambda(
new_row,
original_array,
[replacement_col_idx],
let(
idx_col, if(isomitted(replacement_col_idx), 1, replacement_col_idx),
data_mask, choosecols(new_row, idx_col) <> choosecols(original_array,idx_col),
filtered_array, filter(original_array, data_mask),
hstack(filtered_array, replace_row)
)
);

columnMask =
lambda(
value,
comp_to_array,
[comparison_operator],
[column_idx],
[value_idx],

let(
operator, if(isomitted(comparison_operator),”=”,comparison_operator),
comp_func, lambda(operator, lambda(value, comp_array, switch(operator, “=”, value=comp_array, “<>”, value<>comp_array,”Not yet implimented”))),
col_idx, if(isomitted(column_idx), 1, column_idx),
val_idx, if(isomitted(value_idx), 1, value_idx),
adj_value, if(COLUMNS(value)>1, CHOOSECOLS(value, val_idx), value),
comp_col, choosecols(comp_to_array, col_idx),
comp_func(operator)(adj_value, comp_col)
)
);

track_state =
lambda(
last_state_string, current_trans,
LET(
lots, array.deserialize_string(last_state_string),
lot_to_add, INDEX(current_trans, 1, 1),
prior_lot_values, IFERROR(
FILTER(lots, array.columnMask(lot_to_add, lots), ERROR.TYPE(3)),
ERROR.TYPE(3)
),
filtered_array, FILTER(lots, array.columnMask(lot_to_add, lots, “<>”), ERROR.TYPE(3)),
replacement_line, IF(
ISNA(prior_lot_values),
current_trans,
HSTACK(
lot_to_add,
(INDEX(prior_lot_values, 1, 2) + INDEX(current_trans, 1, 2)),
(INDEX(prior_lot_values, 1, 3) + INDEX(current_trans, 1, 3))
)
),
final_array, IF(
OR(TRIM(last_state_string) = “”),
replacement_line,
IF(OR(ISNA(filtered_array)), replacement_line, VSTACK(filtered_array, replacement_line))
),
final_array
)
);​

​I’m curious what you all think of this approach for managing state in excel with minimal computational impact.  I’m sure after a few thousand different items to track, performance may be implicated, but the formulas initially feel like they will create static values that don’t have to be recalculated with any frequency.  Skip towards the end if you just want to see the formulas. I think one of the important ideas here is that this formula can be used within a table column the same as any other formula that doesn’t return an array, the difference being that calculations are not lost between steps of the row and the only information a calculation needs is the limited state info in the prior state.Any comments welcome.  If you’ve found a better way to do this, I’d be curious to know.  I am limiting myself to using only native excel formulas/functionality plus excel labs. P.S.  The formulas have one or two undeveloped ideas because they are not essential.  For instance, there is one inline lambda that uses a switch to return a comparison function for data masking that has only implemented the equals and does not equal operators. **********Description******************** General idea is such – write a series of formulas that serialize and deserialize arrays and combine it with an efficient mechanism to access the most recent state.  The example uses the idea of lots of items where each lot has a quantity and cost – transactions can either increase the quantity (and cost) or decrease it.  The state being managed is the existent lots, their quantities, and their costs. columns are simple:control; date; lot; qty; cost; state So here is the overall structure:table formula checks control column to see if the current row impacts the state –       if it doesn’t, return nothing,       if it does, move on             if it is the first control number, just serialize the row data            if it isn’t, find the prior state and update it The way it updates the state is by1) deserializing the prior state2) determining whether the prior state already included the current row’s item3) updating that value if so or just returning the current rows values,4) filtering the prior state to remove the current row’s item5) vstacking the filtered array onto the current row’s entry (potentially updated), and6) serializing the current state. Using 40 rows as an example, I might end with a serialized state that looks like this:lot_H,65,650;lot_I,100,1000;lot_J,45,450;lot_K,70,700;lot_L,30,300;lot_A,135,1350;lot_B,150,1500;lot_C,145,1450;lot_D,90,900;lot_E,120,1200;lot_F,80,800;lot_G,170,1700and deserializes to this: lot_A 135 1350lot_B 150 1500lot_C 145 1450lot_D 90 900lot_E 120 1200lot_F 80 800lot_G 170 1700lot_H 65 650lot_I 100 1000lot_J 45 450lot_K 70 700lot_L 30 300 using this function: SORT(array.deserialize_string(I57)) table formula:

=IF(
TRIM([@lot]) = “”,
“”,
IF(
[@control] = 1,
array.serialize_array(Table68[@[lot]:[cost]]),
LET(
current_trans, Table68[@[lot]:[cost]],
last_state_ctrl, MAX(
FILTER([control], ([control] < [@control]) * ([lot] <> “”) * (2024 <= [@date])),
1
),
last_state, XLOOKUP(last_state_ctrl, [control], [state], “”, 0),
array.serialize_array(array.track_state(array.deserialize_string(last_state), current_trans))
)
)
)

module formulas:

deserialize_string = LAMBDA(state_string, TEXTSPLIT(state_string, “,”, “;”, FALSE));
serialize_row = LAMBDA(row, TEXTJOIN(“,”, FALSE, row));
serialize_array = LAMBDA(state_array,
REDUCE(
,
BYROW(state_array, LAMBDA(r, serialize_row(r))),
LAMBDA(acc, current_row, acc & “;” & current_row)
)
);

serialized_wrapper = lambda(state_string, func_to_apply, serialize_array(func_to_apply(deserialize_string(state_string))));

replace_row =
lambda(
new_row,
original_array,
[replacement_col_idx],
let(
idx_col, if(isomitted(replacement_col_idx), 1, replacement_col_idx),
data_mask, choosecols(new_row, idx_col) <> choosecols(original_array,idx_col),
filtered_array, filter(original_array, data_mask),
hstack(filtered_array, replace_row)
)
);

columnMask =
lambda(
value,
comp_to_array,
[comparison_operator],
[column_idx],
[value_idx],

let(
operator, if(isomitted(comparison_operator),”=”,comparison_operator),
comp_func, lambda(operator, lambda(value, comp_array, switch(operator, “=”, value=comp_array, “<>”, value<>comp_array,”Not yet implimented”))),
col_idx, if(isomitted(column_idx), 1, column_idx),
val_idx, if(isomitted(value_idx), 1, value_idx),
adj_value, if(COLUMNS(value)>1, CHOOSECOLS(value, val_idx), value),
comp_col, choosecols(comp_to_array, col_idx),
comp_func(operator)(adj_value, comp_col)
)
);

track_state =
lambda(
last_state_string, current_trans,
LET(
lots, array.deserialize_string(last_state_string),
lot_to_add, INDEX(current_trans, 1, 1),
prior_lot_values, IFERROR(
FILTER(lots, array.columnMask(lot_to_add, lots), ERROR.TYPE(3)),
ERROR.TYPE(3)
),
filtered_array, FILTER(lots, array.columnMask(lot_to_add, lots, “<>”), ERROR.TYPE(3)),
replacement_line, IF(
ISNA(prior_lot_values),
current_trans,
HSTACK(
lot_to_add,
(INDEX(prior_lot_values, 1, 2) + INDEX(current_trans, 1, 2)),
(INDEX(prior_lot_values, 1, 3) + INDEX(current_trans, 1, 3))
)
),
final_array, IF(
OR(TRIM(last_state_string) = “”),
replacement_line,
IF(OR(ISNA(filtered_array)), replacement_line, VSTACK(filtered_array, replacement_line))
),
final_array
)
);​   Read More

​

I have a data from October 2023, but when I am using timeline slicer, it shows me from Jan 2023. I want to fix this.

​I have a data from October 2023, but when I am using timeline slicer, it shows me from Jan 2023. I want to fix this.  Read More

​