chart display by different date period

[Anonymous]

Hi all

this is a sale report, and i wanted display the sale for each product for each different date period

the current data file does not have this info, so i was wondering if it is possible to add in?
Example date period Jan 15-Mar16 or Dec 16 to Mar17.

any advice is appreciated. Thank in advance

https://gofile.io/?c=pMaIxB

[MFelix · Accepted solution]

Hi @Anonymous,

You can do one of two things make an additional column on the sales table with an IF syntax that check if the date is within the sales period.

Another option is to create an additional table with the sale period and a max and min date for each period and then make a measure that uses that new table.


Regards,
MFelix

[mussaenda · Accepted solution]

Based on my understanding, this is what you want to achieve:

[MFelix]

Hi @Anonymous ,

Not really sure if I understand your request but have you tried to make the use of the data column on your model and the slicer between dates?

Can you explain a little bit better what is the expected result.

Regards,

MFelix

[Anonymous]

@MFelix 
hihi...as i have many products, so instead of manually using slicer between dates, is there a way to add this date period into the data and then using it as a slicer for the products.

If it cannot be done, i wonder how to using the slicer manually if i need a product to display period between different years?

For example: Dec 16 to Mar17.

[MFelix]

Hi @Anonymous ,

What do you mean by date period on  your question? Do you want to have a column with the information that a specif product was only solde between Dec 16 and Mar 17?

Or do you want to create some pre definied periods and used them on a slicer?

Regards,

MFelix

[Anonymous]

@MFelix 

The promotion period is currently not in my data source, so i was wondering if it is possible to add into data source.

But would this then upset the existing file?

Also what format should this date period be, so that it can be used as a slicer later?

[MFelix · Accepted solution]

Hi @Anonymous,

You can do one of two things make an additional column on the sales table with an IF syntax that check if the date is within the sales period.

Another option is to create an additional table with the sale period and a max and min date for each period and then make a measure that uses that new table.


Regards,
MFelix