topic Re: Divide all Returned sales values on only sales values in January from the same year in DAX Commands and Tips

Divide all Returned sales values on only sales values in January from the same year

Anonymous — Thu, 18 Nov 2021 09:01:54 GMT

Hi all

I asked this question ywo days ago , but seems I missinterpert my problem ,

https://community.powerbi.com/t5/Desktop/Divide-all-dates-values-on-a-a-specific-date-value-from-a/m-p/2191860#M802754

I will try to give more details her

I have the the following table:

And I would like to great new measure (column) that can fill all months sales with the value of January and then divide this is the returned column , meaning that I ma interesting in knowing the return ratio for each month comparing with only September .

The resulted table should be like this :

Where E2 = D2/C2

Thanks in advance

Regards

Re: Divide all Returned sales values on only sales values in January from the same year

amitchandak — Thu, 18 Nov 2021 10:01:36 GMT

Anonymous , Join you table with date table having year and month column and try measure like

% = divide(sum(Table[return]) , sumx(filter(allselected(Date), Date[Year] = max(Date[Year]) && Date[Month] =1), Table[sales]) )

Re: Divide all Returned sales values on only sales values in January from the same year

V-lianl-msft — Tue, 30 Nov 2021 09:29:29 GMT

I see that the thread you released before has been resolved, this solution meets your needs. If there are any problems, please let me know.