Results 1 to 1 of 1

Thread: PQ - Number.From in PowerBi

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    238
    Rep Power
    7

    Cool PQ - Number.From in PowerBi

    (question from the web)

    Could somebody please tell me what this line in the Applied Steps in PowerBI would be doing, it adds a column, and it looks like it takes a number from Date A, but I'm not sure what the double period between the two NumberFrom's does.

    Table.AddColumn(#"Changed Type","Custom",each {NumberFrom([DateA])..Number.From([From([Dateb])})
    imho this formula doesn't have a proper syntax but generally speaking this is a List
    A list value is a value which produces a sequence of values when enumerated. A value produced by a list can contain any kind of value, including a list. Lists can be constructed using the initialization syntax, as follows:
    Code:
    { 1, 5..9, 11 } // { 1, 5, 6, 7, 8, 9, 11 }
    Last edited by sandy666; 02-19-2021 at 01:46 AM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. Replies: 3
    Last Post: 03-31-2013, 06:18 AM
  2. Adding specfic number to a available number in previous cell.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 03-02-2013, 01:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •