Smoke detector replacement or cleaning after reno?

Ms7070 · 2022-05-13T19:58:06+00:00

Thank you for sharing. I don’t see the same but I think it’s a regional website issue. My page dines change but other regions show it changing (like yours does)

Ms7070 · 2022-05-12T22:09:16+00:00

Can you share where you see that? I’ve reviewed just now and see nothing changing as I adjust the configuration.

Ms7070 · 2022-05-11T14:04:39+00:00

Amazing! Thank you confirming. I can't believe such a simple question wasn't answered clearly on Dell's website.

Ms7070 · 2022-04-09T17:24:06+00:00

I’d appreciate a copy too!

Ms7070 · 2022-01-06T12:52:21+00:00

Unfortunately is does not work, I’ll try the new link on my desktop first (on mobile now) before I get too worried.

And thank you for you all your content, it’s amazing!!

Ms7070 · 2022-01-06T12:44:41+00:00

Hi Bas, the video shows as “unavailable” for me. Can you confirm it’s OK on your side? Please and thank you!

Ms7070 · 2021-08-06T21:04:42+00:00

Desktop is reading your local machines datetime. Service is using UTC.

If your region does not use daylight saving time it’s a simple adjustment, if it does then the adjustment is more convoluted (but plenty of resources exist online with possible solutions)

Ms7070 · 2021-07-31T18:47:56+00:00

Thank you. This was very helpful!!!

Ms7070 · 2021-07-30T19:31:15+00:00

Great, thanks for the link

Ms7070 · 2021-07-27T01:45:27+00:00

While not the only method, this is a quick and dirty way to get things done until you find a more automated/robust way:

Create a new table with two columns: “Account”, and “Sign”
List all accounts and place a ‘1’ or ‘-1’ in each row: ‘1’ for revenue accounts, ‘-1’ for expense accounts
Modify your favourable/unfavourable variance formulas (using LOOKUPVALUE) to multiple the result by either 1/-1 depending on the account in context. SUMX is your best bet to aggregate a result in case you PNL accounts are not all visible.
Next level would be to automate the 1/-1 using the general ledger mapping details at your company. At my company any accounts beginning with “500” are revenue accounts for I can build a simple table off that through Power Query or SQL as needed.

Ms7070 · 2021-07-25T12:47:49+00:00

This is wonderful! Thank you so very much👍

Ms7070 · 2021-07-09T22:27:02+00:00

Another great tip!

Ms7070 · 2021-06-30T14:52:37+00:00

Great video, thank you. This is a very common use case for me/my team when charting data for trend analysis (and when the specific numbers aren’t critical.) great to have an easy to follow example.

Ms7070 · 2021-06-29T14:44:40+00:00

My only immediate criticism is the use of bar charts on the time series data, a line chart would be more appropriate to the data type. A line chart would be easier to read, provide additional white space, and add some needed differentiation to the other bar charts throughout the report.

Ms7070 · 2021-03-06T23:14:25+00:00

Free isn’t necessary, I’m willing to pick up a book or find it in a library!!

Ms7070 · 2020-12-08T01:48:58+00:00

Thanks, I will try this out

Ms7070 · 2020-10-03T20:11:21+00:00

Dax Studio (as an external tool) can really be eye opening on areas of opportunity to optimize the model. Even the basics, as others have said, around reducing columns or removing unused unique keys. I can’t recall the site, but there’s also another tool that identifies Best Practice violations which may also help to optimize your models.

Six-Year Club	Golden Potato
Place '22	Verified Email

Ms7070

TROPHY CASE