measure a label

Question

Hello,I'm a relatively new user of Power BI. I want to create a measure. For example, all the clients enrolled in the last month (registration date is already a field in my database) are marked as "NEW". How can I do that?Thanks for your advice.KOCHA

marcelsmaglhaes · Answer

Hi&nbsp;KOCHA&nbsp;&nbsp;If you want label a new customer, is better create a New Column in the customers table. If you wanna do that using DAX, you can try the measure bellow.If this post helps, please mark as solved.&nbsp;Regards,Marcelnew_customer=VAR __current_month&nbsp;= MONTH(TODAY())VAR __current_year =&nbsp;YEAR(TODAY())RETURNIF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;YEAR(YOUT_TABLE[REGISTRATION_DATE]) = __current_year &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ( MONTH(YOUT_TABLE[REGISTRATION_DATE]) = __current_month ||&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MONTH(YOUT_TABLE[REGISTRATION_DATE]) = __current_month-1)&nbsp;&nbsp;, "NEW CUSTOMER",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "old customer")

kocha · Answer

Unfortunately, it doesn't work. The visual doesn't display when I added this new measure.&nbsp;

marcelsmaglhaes · Answer

You created a calculated column?&nbsp;Tutorial: Create calculated columns in Power BI Desktop - Power BI | Microsoft Learn

mlsx4 · Answer

Hi&nbsp;KOCHA&nbsp;&nbsp;Do you have a column with "new" as values or do you need a column to create it?Also, can you share how is your data structured? You can put A, B, C 1234 to keep confidentiality

kocha · Answer

I can't create it because the dashboard is directly on another database source. Let me check if there is a workaround. Thanks.&nbsp;

Forum Discussion

measure a label

5 Replies

Related content

Stacked Column Chart Data Labels

Data Label

Measure

DAX Measure

Security (RLS & sensitivity labels)