What We Want: We want to create a table that stores the following variables for each department: date, department name, and the number of unread emails. We have experimented with several approaches but have not yet found a way to automatically append a new row for each department with t...
with both thick and thin parts, and the marketing vitality has been partially boosted. In the traditional market, there has been an increase in the number of listed stores, and the market distribution and marketing share have
This week, the volume of mass fabric in China Textile City is still insufficient. Due to the end of 2011, the production and marketing of traditional markets are gradually being adjusted, and the self production capacity of the grey fabric manufacturers is gradually compressed, the inventory rate...
I have a store dashboard that consists of stores and store atributes in one table, and sales metrics in another. I would like to create a dashboard where I select the store from a slicer, that then does two things: Compares store sales metrics to benchmark sales metrics ie. av...
have increased the number of dispersive, small batch and multi varieties. The turnover of knitting warp knitted fabric and bedding flannelette is relatively smooth. Some of the retail stores are interested in orders and proofing, and the turnover is small. Recent polyester 50D in Textile City ...
There is also an online portal which stores sales data in the form excel. We want to compare the number of sales are coming from Portal vs. all the sales captured in data warehouse. The insights are: 1. How many sales are coming from Portal against all the sales 2. sales ...
THEN ADD SORTORDER column using the two extra columns created above and in this order : SortOrder = CONCATENATE(FieldYear,FieldMonth) Key now is to change the Cortorder datatype to Whole Number (accept the warning that stores your data differently) Next, Sort Datefield by the 'Sort...
I would like to compare only those stores where there are sales only in the selected period and the period of the previous year. The result I want to get: Store SalesforPeriod- SalesForPreviousYear- Sales 2 years ago- StoreA--- 100 50 80 StoreB--- 200 80 I tried to use the ...
Solved: I am trying to pull in the 3 closest stores to the store in the row. Store Latitude Longitude A 43.856024 -111.774702 B 42.014946 -87.768669
This way Power BI stores credentials for the data source based on the common part of the API URL and uses those credentials for all calls to the API with the same common part of the URL. Message 4 of 5 1,010 Views 3 Reply blopez11 Resident Rocks...