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

 

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.

      • MattAllington's avatar
        MattAllington
        Community Champion
        9 years ago

        I was intending that you use the month column (sorry that wasn't clear)

         

        =if(day(table[date]) <=15,Calendar[MM YYYY] & " - ' & "Early",Calednar[MM YYYY] & " - ' & "Late")

         

        I guess this will also work

         

        =if(day(table[date]) <=15,format(Calendar[date],"MM YYY") & " - ' & "Early",format(Calendar[date],"MM YYY") & " - ' & "Late")