Posts

Showing posts with the label DAX

When One Agent Tried to DO Everything

-
Image
When One Agent Tried to DO Everything The second article in my Finance Agent series My first Collection Manager Agent worked well - until I kept giving it more jobs. What started as a customer-review assistant grew to hanle automated credit-hold analysis, collection-call preparation, and customer email drafting. Each addition made sense. Together, they created a problem. In my first article, I mentioned the importance of narrower scope. This time, I want to show you what happened when I ignored that lesson. Watch: Why I Split One Agent Into Three What the First Version Was Asked to Do The first Collection Manager Agent started with a simple job. Review a customer. Pull the aging, the credit limit, the open invoices. Tell me what to do next. It did that well. Then I started adding to it. • I wanted it to react automatically when a sales order was placed on credit hold. • I wanted it to prepare me for a collection call. • I wanted it to review disputes and promises to pay. • I wa...
Post a Comment
Read more

Covid Dashboard - Article 6 - Creating a group for a slicer

-
Image
I will continue to build on my earlier posts about my  COVID19 Dashboard .    In this series, I have written a few different blog articles describing not only how I built it, but some things I learned in the process. The current list of topics include: Working with growing CSV files Using index and merge when transforming data Using time functions to calculate the daily change Reporting based on the population Working with maps, setting data types correctly Today I am going to look at a question one person asked me.  When they were using the dashboard, they wanted to be able to filter the global results by countries of similar size. After thinking about this for a while, I decided on the following approach.  There are probably different approaches that can be used, and that is one of the things I really like about Power BI.  In this case, I tried to take a very simple approach. Step 1 - I had to decide how I wanted to group the count...
Post a Comment
Read more

USERELATIONSHIP in DAX

-
Image
A common problem many users face it the fact that there are multiple date fields in their tables, and when they want to use a date dimension, Power BI only allows for on active relationship between the two tables. For example, I have a dimension table from my leasing software that included information on each lease including the commencement date of the lease and the expiration date of the lease.   In Power BI when I use a separate date dimension (which I always recommend for many different reasons), I can only link the dimension table to date table with one active relationship.    See screen shot below. Since most of my visualizations will be based on the Commencement Date, I will make that the active relationship.   However, I would like to create a visualization showing my leases by expiration date.   In order to do this, I have a couple options. 1.        I could create a second date dimension table in my...
Post a Comment
Read more