Forum Discussion

KOCHA's avatar
KOCHA
New Member
2 years ago

measure a label

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 ...
Need Help
Show and Tell
marcelsmaglhaes's avatar
marcelsmaglhaes
Icon for Super User rankSuper User
2 years ago

Hi KOCHA 

 

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. 

Regards,
Marcel

new_customer=
VAR __current_month = MONTH(TODAY())
VAR __current_year = YEAR(TODAY())
RETURN
IF(
           YEAR(YOUT_TABLE[REGISTRATION_DATE]) = __current_year &&
          ( MONTH(YOUT_TABLE[REGISTRATION_DATE]) = __current_month ||
              MONTH(YOUT_TABLE[REGISTRATION_DATE]) = __current_month-1)  , "NEW CUSTOMER",
            "old customer")
  • KOCHA's avatar
    KOCHA
    New Member
    2 years ago

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

     

    • mlsx4's avatar
      mlsx4
      Icon for Memorable Member rankMemorable Member
      2 years ago

      Hi KOCHA 

       

      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's avatar
        KOCHA
        New Member
        2 years ago

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