Keyboard and Rat

A place for my computer discoveries

[keyboardandrat]

In Power BI, the tilde (~) is an escape character and will allow you to filter on characters like asterisk (*) without them being considered wildcards.

For Example:

Contains ~*

Will filter for items with * in the name, not every item.

[keyboardandrat]

In Microsoft Dynamics 365 F&O, a mobile device menu item can be added called Data inquiry. This allows you to present information from a specific table to the warehouse workers. This is really convenient. The query supports table joins but the field list doesn’t support fields from joined tables. This is less convenient.

[keyboardandrat]

In Microsoft Dynamics 363 F&O, if a warehouse worker’s mobile device freezes, you can cancel the workers session under Modules > Warehouse management > Inquiries and reports > Work user sessions, select the worker, and hit End session at the top of the screen.

This will reset the mobile scanner for that worker

[keyboardandrat]

IP phones wont connect to your freePBX server? Check your NAT Settings under Settings > Asterisk SIP Settings > NAT Settings and set the external address of the server.

I am running freePBX inside docker and the server was giving out its address for the docker network and not its address from the main router. Setting the external address in Asterisk fixed this problem and allowed phones to connect.

[keyboardandrat]

If you need a value to be exempt from slicers in Power Bi, you can use the ALL() function in your calculation.

For example:

Calculate(Sum(table[column]), ALL())

will sum all values in the column no matter what slicers are active.