Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    327

    RLS Sharepoint embedded report

    Hi Guys,

    I've got a question about RLS in PowerBI.

    My problem:
    When i give someone access to my reports without a role, they see all data.
    Is it possible to set my dataset to like a RLS...
  2. PowerBI Dataflows (cant see it in the service)

    Hi all,

    I work at a school and got a (probably educational) powerbi pro license.
    I want to experiment with powerbi dataflows but cannot see the functionality in the powerbi online service.
    ...
  3. Replies
    0
    Views
    361

    PowerBI and sharepoint authorization

    Hi all,

    I've got an authorization issue with publishing PowerBI reports to sharepoint.
    As soon as i publish a PowerBI report on my sharepoint page, everyone with acces to my "report" sharepoint...
  4. Replies
    0
    Views
    142

    Excel online sheet protection

    Hi Guys,

    I hope you guys can help me out with this problem.

    I want to share a file on Sharepoint with 9 different users that use Excel Online (So macro's wont work).
    Each user has his own...
  5. Replies
    1
    Views
    162

    worksheet_change problems

    Hi guys,

    I've written some code to protect certain ranges from unnoticed editing. unfortunately its not working yet.

    Ranged H9 - X(COUNTED nr) must activate the macro.



    Sub...
  6. Replies
    6
    Views
    145

    Re: Loop for Countif function from a range

    Haha, you are welcome!
  7. Replies
    6
    Views
    145

    Re: Loop for Countif function from a range

    Hello Emeric,

    Change:


    Set Task1 = Worksheets("Sheet2").Range("A2:A3000")
    Set Task2 = Worksheets("Sheet2").Range("B2:B3000")
    Set Task3 = Worksheets("Sheet2").Range("C2:C3000")|
  8. Replies
    6
    Views
    145

    Re: Loop for Countif function from a range

    Hello Emeric,

    I've made your code dynamic. Just adjust the ranges and sheetnames.



    Public Sub countTaskocc()

    Dim Task1 As Range
    Dim Task2 As Range
  9. Re: Separating single cell value into different cells

    Hello,

    May I ask why you don't use a formula behind the column with values?

    If your values are in column A it would be:

    Column B: =IF(A1<=50000;A1;IF(A1>50000;50000))
    Column C:...
  10. Replies
    4
    Views
    1,088

    Re: Excel Conditional Loop without VBA?

    You can use a pivottable for this I guess. I've made a simple setup:

    Column A: Names
    Column B: Dates
    Column C: Status

    Select data - Insert - Pivottable

    Rows: Date & Name
    Columns: Status...
  11. Re: Getting a range data of a column from Excel 2016 through VBA

    Hello Leila,

    I use the following code for looping through the cells in column A. It puts "Hello" in the used range.




    Dim lr As Long
    lr = Cells(Rows.Count, 1).End(xlUp).Row
    For i = lr...
  12. Thread: Lookup help

    by MrJoosten
    Replies
    1
    Views
    95

    Re: Lookup help

    Hello Tony,

    I think this will help you.

    =IF(C11="ZF",IF(VLOOKUP(C201057,'TES MASTER'!A:D,2,FALSE)=VLOOKUP(A201057,'TES Tony Master'!A:D,2,FALSE),VLOOKUP(A201057,'TES Tony...
  13. Re: If one cell is blank, Show what is in the adjacent cell.

    Not sure if i follow. But try this in column C:

    =IF(A2:A8 = "",B2:B8,"")
  14. Replies
    2
    Views
    322

    Re: How do i slice this measure?

    Thanks a lot Gaz, Allselected was the key!

    Hope this helps other people too!
  15. Replies
    2
    Views
    322

    How do i slice this measure?

    Hello guys,

    I've got a measure that works perfectly. The only downside is, I cant use my slicer(s).

    This is the code I've got so far:


    Cumulative line ACT 2017 =
    Calculate(...
  16. Re: Table sum gets #value! when reference cell is empty

    Thank you Steve! Solved.
  17. Table sum gets #value! when reference cell is empty

    Hi Guys,

    [@[DB]]+[@[Baseline]]+[@[2 Baseline]] results in #Value! because the [Baseline] cells are empty. DB has value.

    Why does it get the #value!? I expect for example 50+empty+empty = 50....
  18. Replies
    5
    Views
    6,438

    Re: Formula error variant data-type

    You are the man! Thanks Norie! :)

    Good to keep that in mind.
  19. Replies
    5
    Views
    6,438

    Re: Formula error variant data-type

    And yes, it returns empty or the value from HL. :)
  20. Replies
    5
    Views
    6,438

    Re: Formula error variant data-type

    Hi Norie,

    Thanks for your reply.
    Column HL is a decimal number data type.

    Could this cause the error?

    Thx.
  21. Replies
    5
    Views
    6,438

    Formula error variant data-type

    Hi Guys,

    I'm starting with PowerBI and I need some help with a formula. (calculated column)
    Maybe my formula is very much excel like, and that's why I go wrong...

    Formula:


    Column =...
  22. Re: Need Help saving workbook with VBA (specific filename)

    Sub Save()
    Dim s1 As String
    Dim s2 As String
    s1 = Cells(1, 1).Text
    s2 = Cells(1, 2).Text
    ActiveWorkbook.SaveAs Filename:="" & s1 & "Report_" & s2, FileFormat:=53, CreateBackup:=False...
  23. Re: If Vlookup array table contains NOT wildcard

    Hi,

    Try this:

    =VLOOKUP("*"&A3&"*";$A$15:$A$19;1;FALSE)

    assuming your RAW DATA is from A15 to A19.
  24. Replies
    1
    Views
    97

    Re: Add defauld cell value VBA

    Sub HOL()
    ' HOL Macro

    With Selection.Interior
    .Color = 65280
    End With
    Activecell.value = "0"
    End Sub
  25. Replies
    2
    Views
    878

    Re: xldown with one row

    Hi,

    Change:


    Range("c2").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
Results 1 to 25 of 115
Page 1 of 5 1 2 3 4