CANCEL SALES

[ALVIV99]

Hey, I'm very new in Power Bi and I have an issue.

I need to create a measure of Cancel Sales, the problem is that I have only one column of Sales that in there includes the Sales and Cancel Sales and also two Dates (FECHA_DOC) and (FECHA_ CANCELA) 

FECHA_DOC = When the sale was made

FECHA_CANCELA = If the customer didn't want to buy 

I want to take the Cancel Sales with FECHA_CANCELA

I use this formula

TOT SALES = SUM(FACTURAS[TOTAL SALES]) "The column with the sales and cancel sales"

CANCEL SALES = CALCULATE([TOT SALES]), DATEADD(FACTURAS[FECHA_CANCELA],0,MONTH))

But it doesn't take the date of FECHA_CANCELA instead it takes FECHA_DOC.

If someone can help me, I would appreciate it very much.

@mahoneypat @Anonymous @v-kelly-msft @v-jingzhang @v-yingjl 

[ALVIV99 · Accepted solution]

I found the answer while searching the internet, I use USERELATIONSHIP

1) I took my Column (FECHA_CANCELA) and connected with my Calendar Table(CALENDARIO[DATE]),we can see that when these two tables are connected, it will not be a primary connection but a secondary one, since a dotted line will be seen.

2) Now I use this new Meassure

CANCEL SALES = CALCULATE( [TOT SALES] , USERELATIONSHIP(CALENDARIO[Date],FACTURAS[FECHA_CANCELA]))

Now I can see my CANCEL SALES

All in a NEW MEASURE not in a column

[Anonymous]

Hi @ALVIV99 ,

Now that you have found a solution, please mark your own reply as the answer, and more people will benefit from it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.