Forum Discussion
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 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.
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")
6 Replies
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")
How can I concatenate the value of Early or Late with Month and Year?
i.e. June 2017 - Late
The same as you would in Excel. table[Column1] & " - ' & table[Column2]