Forum Discussion
chart display by different date period
- 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 Based on my understanding, this is what you want to achieve:
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
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.
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
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?