Search:

Type: Posts; User: cajste; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    0
    Views
    345

    Power query - expanding lists to columns

    Hi,

    I have a problem importing a json file into power query. A record looks like below. Expanding user and client is not a problem, new columns are inserted as they should, but expanding custom...
  2. Thread: Future startups

    by cajste
    Replies
    1
    Views
    298

    Future startups

    Hello,

    I have a data modell containing among other things sales date and start date and I need to calculate the number of future startups at any givet date that were sold on or before that date. I...
  3. Replies
    6
    Views
    498

    Re: Problem with actuals vs budget

    Thanks! Been looking at that before but did not get it to work. Solved the problem now by setting up an extra dimension table.
  4. Replies
    1
    Views
    391

    Re: Relationship Activation

    The error message says: "You can't create a active relationship between Leavers and Month because that would introduce ambiguity between tables Month and Group. To make this relationship active,...
  5. Replies
    6
    Views
    498

    Re: Problem with actuals vs budget

    Thanks! Since I want to use this in Power BI I guess a macro won't solve the problem. I'm pretty sure I've seen a DAX-solution to this problem somewhere but I can't find. Anyone have any ideas?
    ...
  6. Replies
    6
    Views
    498

    Problem with actuals vs budget

    Hi,

    I've built a analysis modell for actuals vs budget. My boss wants to be able to see the verification text for the actuals while still having having the budget figurrs in the same pivot. The...
  7. Thread: Macro question

    by cajste
    Replies
    2
    Views
    169

    Re: Macro question

    Thanks, I'll try it!
  8. Thread: Macro question

    by cajste
    Replies
    2
    Views
    169

    Macro question

    I have a big range of data where where some of the cells have the wrong format when I get the it and calculations will not work because of that. If I selcet a cell, pushes F2 and then Enter the...
  9. Replies
    7
    Views
    655

    Re: Index & match multiple columns

    Works great, thanks!!!
  10. Replies
    7
    Views
    655

    Re: Index & match multiple columns

    Brilliant, thanks!

    I tried to get it to sum multiple rows, the formula looking like below, but it doesn't return the correct number. Am I doing something wrong?
    ...
  11. Replies
    7
    Views
    655

    Re: Index & match multiple columns

    I tried that the sumif but haven't been able to get it to work.

    Below is an example of the table I'm working with, to give some context. Sorry for the poor formating but if pasted into Excel it...
  12. Replies
    7
    Views
    655

    Index & match multiple columns

    Hi,

    As part of our monthly report I prepare a financial summary with actuals, budget and forecast per for the month, year to date and full year. Actuals, budget and forecast figures are in...
  13. Thread: Gantt chart

    by cajste
    Replies
    0
    Views
    176

    Gantt chart

    Hi,

    I have a number of consultants working for a number of customers and we invoice per hour. I have a database with consultant, customer, start/end date/time and duration for each occasion worked...
  14. Re: Conditional formatting with two conditiions

    Thank's alot, will try it!

    I came up with a similar solution, using the wingding font in a formula and conditional formatting to colour the arrows based on different thresholds for each KPI and...
  15. Conditional formatting with two conditiions

    Hi,

    I've been asked to setup a conditional formatting with coloured arrows based on two criterias. The direction of the arrow is determined by the development from last month and the colour of the...
  16. Replies
    0
    Views
    471

    Problems updating linked tables

    Hi,

    I am running a win 7 with Excel 2013, 64 bit, Swedish version. I try to update a linked table in the data modell and get an error message saying:

    Exception from HRESULT: 0x800A03EC...
  17. Replies
    1
    Views
    1,013

    Slicer information in pivot chart header

    Hi,

    I've created a data model and built a report with different pivot charts and slicers to control them. However, I would like to show the selections in the two slicers in the chart title. I've...
  18. Replies
    0
    Views
    137

    Show dependent/precedent cells

    Hi,

    I have a huge budget file wit many cell dependencies. I suspect there are some cells contributes to the result more than once giving an incorrect result. Is there an easier way of...
  19. Re: Is it possible to display a metric at the bottom of a pivot table?

    You're right, probably not the best way to handle your problem and the possibilities to drill down might be limited.

    Listing measures as rows and periods across the top is no problem. Given your...
  20. Re: Is it possible to display a metric at the bottom of a pivot table?

    Sounds like what you have is not a calculated measure but a filter showing the same measure in different contexts. If you create the calculated measures I suggested you will be able to show all three...
  21. Re: Is it possible to display a metric at the bottom of a pivot table?

    I would create 3 calculated measures, one for Current Assets, one for Current Liabilities and then Net working capital as [Current Assets]-[Current Liabilities].

    //Caj
  22. Thread: Min with Filter

    by cajste
    Replies
    9
    Views
    746

    Re: Min with Filter

    Thanks Mike, I had to add some information to the ID column to make it unique and it seems to be working just as it should!

    Of course, when one question is answered the next is asked. Each time...
  23. Thread: Min with Filter

    by cajste
    Replies
    9
    Views
    746

    Re: Min with Filter

    Thanks, I'll give a try tomorrow!

    //Caj
  24. Thread: Min with Filter

    by cajste
    Replies
    9
    Views
    746

    Re: Min with Filter

    No, V_TrainRunningInfo[TimeAtLocation] does not contain unique values. However V_TrainRunningInfo[TimeAtLocation] should be unique for each set of [PathIdent-Departure].

    //Caj
  25. Thread: Min with Filter

    by cajste
    Replies
    9
    Views
    746

    Re: Min with Filter

    Mike, I really appreciate the help!

    I tried the code but get an error like this (my translation): "Calculation error in column V_TrainRunningInfo'[]: A table with more than one value were stated,...
Results 1 to 25 of 66
Page 1 of 3 1 2 3