Dashboard Logic and Question

[irnm8dn]

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 the month, then "Early".  >15th of the month "Late".  

I have never done this as it petains to date and I am looking for suggestions.

[MattAllington · Accepted solution]

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")

[irnm8dn]

@MattAllington

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

i.e. June 2017 - Late

[MattAllington]

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

[irnm8dn]

@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]

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")

[irnm8dn]

@MattAllington

Thanks!