Forum Discussion
William_Moreno
Helper II
Helper IIReturn null in a specific condition
Hello people, I need help from the experts powerbi. I have the following spreadsheet, formed by the fields: ID_PRODUCT, SALES_MONTH, QTY. From this, I want to create two new columns: FIRST SALE ...
William_Moreno - First will be:
First = MINX(FILTER('Table (27)',[ID PRODUCT]=EARLIER([ID PRODUCT]) && [SALES_MONTH]>=EARLIER([SALES_MONTH]) && [QTY]<>0),[SALES_MONTH])Reviewed
Reviewed = IF([SALES_MONTH]<[First] && [QTY]=0,BLANK(),[QTY])PBIX attached.
Greg_Deckler
Community Champion
Community ChampionWilliam_Moreno - First will be:
First =
MINX(FILTER('Table (27)',[ID PRODUCT]=EARLIER([ID PRODUCT]) && [SALES_MONTH]>=EARLIER([SALES_MONTH]) && [QTY]<>0),[SALES_MONTH])
Reviewed
Reviewed = IF([SALES_MONTH]<[First] && [QTY]=0,BLANK(),[QTY])PBIX attached.
William_MorenoGreg, thank you for your post.
In my pbi archive I've changed just one signal of the function, like this:
First = MINX(FILTER('Table (27)',[ID PRODUCT]=EARLIER([ID PRODUCT]) && [SALES_MONTH]<=EARLIER([SALES_MONTH]) && [QTY]<>0),[SALES_MONTH])