Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dashboard Logic and Question

Looking for some suggestions here with a dashboard I am creating for my business team.   I am trying to assign a value in a column based on a date.  Simply put is something is sold <= the 15th of t...
Need Help
Show and Tell
Tips and Tricks
  • MattAllington's avatar
    MattAllington
    9 years ago

    In Power BI, a dashboard is an object in the power bi service. This sounds like you need a new column in one of your tables. You can create a calculated column using an if statement. The syntax is almost the same as excel

     

    =if(day(table[date]) <=15,"Early","Late")

MattAllington's avatar
MattAllington
Community Champion
9 years ago

In Power BI, a dashboard is an object in the power bi service. This sounds like you need a new column in one of your tables. You can create a calculated column using an if statement. The syntax is almost the same as excel

 

=if(day(table[date]) <=15,"Early","Late")

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    MattAllington

     

    Thanks!

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    MattAllington

     

    How can I concatenate the value of Early or Late with Month and Year?

     

    i.e. June 2017 - Late

    • MattAllington's avatar
      MattAllington
      Community Champion
      9 years ago

      The same as you would in Excel.   table[Column1] & " - ' & table[Column2]

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        MattAllington

         

        I thought so as well, however the format is the full date display i.e. 12/12/2017 - Early

         

        and I am looking for December 2017 - Early

         

        If I format my date column to MM YYYY, once concatenated it displays 12/12/2017 - Early.  Once I concatenate I cannot reformat the date portion of the display.

         

        Thanks again for your input - it's what powers the PBI community.