Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. DAX, how to last value in the period total

    I have a table like this

    Country, headcount, Month
    ==================
    US, 23, May2019
    US, 24, Jun2019
    UK, 27, May 2019
    UK, 27, Jun 2019

    Now Excel pivot-table of Country as row and Month as...
  2. Pivot Table how to show latest value in the period instead of sum total

    I have a table like this

    Country, headcount, Month
    ==================
    US, 23, May2019
    US, 24, Jun2019
    UK, 27, May 2019
    UK, 27, Jun 2019

    Now pivot-table of Country as row and Month as...
  3. Replies
    1
    Views
    100

    Re: Get only data on PivotTable

    any one know the answer
  4. Replies
    1
    Views
    97

    How to get data from Excel online

    I have a datasource stored on an Excel on Onedrive Business (ie Excel online).
    In a local machine Excel, I goto Data > Get Data > From Web and enter the correct path of this Excel online file.
    At...
  5. Replies
    6
    Views
    368

    Re: Any chance mdb to get data from xlsx

    Yes I have tried Google and no luck.

    I tried in mdb link to xlsx it says this version of access cannot link to this newer xlsx. Seems mdb can link xls (older version of xlsx) only.
    Anyone can...
  6. How to use a field as "Not Something" to be condition of a query

    I have a table with one column storing the condition of a query, like "*" etc.
    * means all countries
    Now, apart from "*", there is a need to have a condition "Not US"

    So, can we join table has...
  7. Replies
    6
    Views
    368

    Any chance mdb to get data from xlsx

    I know accdb is better to be used to get linked data from xlsx.
    But for some reason my platform can only use mdb.

    Anyone got any experience mdb can also get linked table data from xlsx ?
    Help...
  8. Re: SQL to multiply value from previous record ? How ?

    Thanks. I will try to study this SQL and see if I can do it also on Access.
  9. Re: SQL to multiply value from previous record ? How ?

    Thanks. What is the SQL if it is in say MsSQL?
  10. SQL to multiply value from previous record ? How ?

    Pls help...
    I have a table like this

    ID , Rate
    ==========
    1, 0.2
    2, 0.5
    3, 0.3
  11. How to get data from another Excel not by PowerQuery

    In the past I recall I can easily link in File 1's range with data from File2's range.
    Now I found I can only import from File2 data using powerquery.

    Where can I use the old method to link from...
  12. Replies
    1
    Views
    100

    Get only data on PivotTable

    If I double click Grand total on PivotTable I get all columns of data including those not on the PivotTable.
    Is there way to get the data only for dimensions that appear in the PivotTable only ?
    ...
  13. How to hide the queries and connection in Excel

    I created several PowerQuery but I want to hide it.
    Now, everyone clicking Data > Query and connection can find it.
    How to make it "invisible" to others ?

    Thanks
  14. Re: How to hide sheet and can be unhide with password

    Thanks Protecting whole workbook may mean they have to key in password at early stage when open ?
    I need to ensure no password is needed in normal operation, until someone try to unhide.
    So Protect...
  15. How to hide sheet and can be unhide with password

    I have several tabs in Excel I need to hide.
    I know we can using Veryhidden but that can still be unhide without password.
    I know we can select VBAProject password but that works only if there is...
  16. How to modify SQL to make * = all in join query

    I have Table A like this

    Country, Product, Sales
    ==========
    US, A, 100
    UK, A, 200
    US, B, 150
    UK,B, 350

    In Table A it is like this
  17. Refresh query/powerquery of my Excel Online file

    I have an Excel data table and a separate Powerquery that result in an output table.
    Of course I can manually set refresh every 1 minute for the query and do the same to refresh the output table...
  18. Can PowerBI refresh the PowerQuery on my Excel data

    I have PowerBI connected to Excel data source (ie not imported but "linked").
    This Excel (either can be on OneDrive business or desktop) contains a powerquery to do data transformation.

    The data...
  19. Re: In Powerquery, How to filter a Table using criteria stored in another Table

    Thanks a lot.
  20. In Powerquery, How to filter a Table using criteria stored in another Table

    Say for example I have a big master table fields:

    Country, Product, Colour, SalesAmount

    I have another table storing the filtering criteria:

    Criteria, Value
    =========
    Country, US
    Product,...
  21. Excel online - how to trigger its powerquery/output table to refresh ?

    I have an Excel file having a Table (data) and a powerquery that result in another table called Output.
    This file has been uploaded to Onedrive Business.

    I need to refresh this output...
  22. How to share Excel on Office 365 Business with some staff without email to them

    I am using Office 365 Business and my Excel file is on OneDrive.
    I want to share it to another staff but I do not want auto email sent to him.
    Is this possible
    Thanks
  23. I need to put Power BI Source Data (xlsx) to cloud

    If I subscribe and pay Power BI Pro (web), is there any space up there I can upload my data.xlsx there and the Power BI then get data from that file in that web space provided by Power BI Pro ?
    ...
  24. Replies
    0
    Views
    216

    put Data.xlsx to website/cloud

    I want to put my data.xlsx to my website
    Now my PowerBI can get the data by web.
    However it does not have security.

    What is the protection I can implement ?
    It is not sensitive data but still I...
  25. SAMEPERIODLAST Year some items are missing if current year is selected

    In my data, 2018 includes items A,B,C only (eg values 10, 20, 30)
    2017 contains data for item A, B, C, D (eg values 15,25,35,45)

    In my Matrix report in PowerBI, I am showing 3 columns:-

    Item,...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4