topic Re: Sales and Buy graph on the same temorality in DAX Commands and Tips

Sales and Buy graph on the same temorality

Anonymous — Thu, 11 May 2023 07:20:56 GMT

Hello,

Someone have already made a Sales and Buy graph like this please :

I would like someone share its methode because my methode prevents me to add some option like filter on a another category.

Re: Sales and Buy graph on the same temorality

v-zhangti — Mon, 15 May 2023 05:55:29 GMT

Hi, Anonymous

You can try the following methods.

Sample data:

Is this the result you expect? If not, can you provide sample data for testing? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

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

Re: Sales and Buy graph on the same temorality

Anonymous — Wed, 17 May 2023 07:29:13 GMT

Hello,

This is what I want but how do you make this calcul and can you filter on a category ?

Re: Sales and Buy graph on the same temorality

v-zhangti — Wed, 17 May 2023 07:46:39 GMT

Hi, Anonymous

What does your source data look like? What does the category look like?

Please refer to the attachment.

Best Regards,

Community Support Team _Charlotte

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

Re: Sales and Buy graph on the same temorality

Anonymous — Wed, 24 May 2023 13:21:45 GMT

I have a database which contain lot of article with a "in" date, "out" date and a shop it's not concern sales and buy but it's the same idea like this :

Article	Shop	IN week	Out week
A1	A	2023-04	2023-05
A2	A	2023-05
A3	B	2023-05	2023-06

For exampl they two IN and one OUT for fifth week of 2023, and if we specify by shop for the A shop I have one IN and one OUT for the same week. I want to make a visualisation like I show in my previous message except that the method I use makes it difficult to filter this visualization by store.