DAX formula

Anything related to PowerPivot and DAX Formuale
Varshi
Posts: 1
Joined: Tue Feb 12, 2019 9:27 pm

DAX formula

Postby Varshi » Tue Feb 12, 2019 10:03 pm

Hi Im new Power BI.I have a requirement like I need to have a new column with lost customers and new customers. with the logic as
If

if previous full year sales(KUD) =0
or
previous year sales <100 (KUSD) AND Current year Growth(PrY%) is > 300% as new customers.

please help me to achieve this logic.

Thanks in Advance
Regards
Varshi
Attachments
new cus.PNG
new cus.PNG (19.42 KiB) Viewed 314 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests