Forum Discussion
chart display by different date period
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 ad...
- 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:
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?
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
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