Forum Discussion

vega's avatar
vega
Resolver III
7 years ago

DAX Suggestions

Hello,

 

I'm not sure where to ask this, but this has always seemed like an active community, so I'd thought I'd take a chance. Does anyone know if there is a way to make suggestions about the DAX language itself? I am trying to create a conditional that returns a table and it seems like this cannot be done with the language as is. If anyone has information as to where I can direct this suggestion, I would appreciate it. 

General Comment
Need Help

9 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    vega it is correct forum to ask DAX question, and now related to your question, it all depends on use case. There are many DAX functions which can create tables:

     

    - Calculatetable

    - Summarize

    - GroupBy

    - SummarizeColumns

    - Filter

    - Values

     

    and many more...

    • vega's avatar
      vega
      Resolver III
      7 years ago

      Right, my problem isn't creating tables. My problem is returning tables from a conditional. For example:

       

      IF(
    <Condition>,
    TableA,
    TableB
)

      OR

      SWITCH(
      <Condition>,
      <Value>,TableA,
      <Value>,TableB
)

      Both of these cases are not possible with the language as is. This is why I am looking for a location to submit suggestions for the language.

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

        vega you can do what you are asking for but I'm not fully clear what you are planning to do after you had table returned based on condition. I think if you explain the full use case it will help to understand what you are trying to solve.