Forum Discussion
Report by date
Hi, I have a table with Pallets ID, quantity and date. These dates are production date, delivery date or modification date of Pallets ID. I add an Index to show events in chronological order....
Hi Anonymous ,
We can create a date table as below and make it related to the fact table.
date = CALENDARAUTO()
Then we can get the excepted result by slicers.
For more details, please check the pbix as attached.
Thanks for the reply.
If the date in the slicer in novembre 11, I need to see No_Palet F003 with quantity of 30. It's always the last know value for the date slicer.