Search:

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

Search: Search took 0.00 seconds.

  1. data connection from several databases same model same SQL

    hi
    I want to get data from SQL, the problem is that in this SQL there are several databases
    each for different company
    the tables and model in each database in the same SQL host is exactly the...
  2. Replies
    1
    Views
    445

    different line per department in line chart

    https://www.flickr.com/photos/156921257@N03/46482426265/in/dateposted-public/

    I want to see both department actual in the same chart different line, department 91 in blue line and department 81 in...
  3. Replies
    0
    Views
    335

    different line per department in line chart

    I want to see both department actual in the same chart different line, department 91 in blue line and department 81 in green line and the budget in blue line. now I can only slice one department all...
  4. Thread: datediff

    by dida
    Replies
    12
    Views
    892

    Re: datediff

    I did it all. but once I add project to the source database and tried to refresh I could not:-( is that the way it works in power query?
    secondly it looks that date diff looks good in the query but...
  5. Thread: datediff

    by dida
    Replies
    12
    Views
    892

    Re: datediff

    AMAZING!!! yes! the final results it's exactly what I needed, I just could not figure how to get to it.
    since I have to table one of dates and the other of project and their start date, I saw that...
  6. Thread: datediff

    by dida
    Replies
    12
    Views
    892

    Re: datediff

    thank you very much but how would it work in power BI? the data I bring from DATABASE to power query and wish to chose the project in the slicer
  7. Thread: datediff

    by dida
    Replies
    12
    Views
    892

    Re: datediff

    thanks but its all would not work in power bi
  8. Thread: datediff

    by dida
    Replies
    12
    Views
    892

    Re: datediff

    if I choose in the slicer project A I wish to get the gap in days from the starting date of project A as follow

    <colgroup><col><col></colgroup><tbody>
    date
    date diff from project


    01/01/2016...
  9. Thread: datediff

    by dida
    Replies
    12
    Views
    892

    datediff

    I Have one table of calendar in the query simply dates. another table of projects and start date of the projects.
    I wish to choose the project and then get in the calendar table another columns that...
  10. Replies
    0
    Views
    839

    add ListBox I created to a ribbon

    cab I add ListBox I created to a ribbon?
  11. Thread: sumifs in VBA

    by dida
    Replies
    1
    Views
    285

    sumifs in VBA

    Hi
    I am looking for a way to do really simple thing and I just can not fild the way.
    I have database, and I want to do quary, I have the following database
    and I want to sumifs all Tel aviv man...
  12. Replies
    0
    Views
    310

    pivot filter, all but

    Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
    I created pivot table and in the report filter I filtered specific customer, the problem is that every time...
  13. Copy and paste link as value and the rest of the formula as formula

    Hi <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
    In many case that I have to report data by several format, I create the format in specific excel file and...
  14. Re: Default Number Format in Excel 2010 worksheet randomly changed to a Date Format

    I understand, but this is not the issue. In another file all the cell got format of EURO currency and again I have to change it manually, new sheet get his entire cell format as Euro...
  15. Re: Default Number Format in Excel 2010 worksheet randomly changed to a Date Format

    I have the same problem, specific file got date cell format by default any new cell in the file and any new sheet and I just can find a way to change it but changing it manually<?xml:namespace prefix...
Results 1 to 15 of 15