Hi Experts,
I have a fact table and a date table connected to each other. Using a slicer in Power Pivot, I want to show for example the last 13 months, based on the month selected in the slicer.
I have searched and searched the internet, all solutions I find is for Power BI. Many of those have I tried in Power Pivot, without any luck.
Is it even possible to get this to work in Power Pivot?
If so, can you help with the DAX code or refer to an article that describes this?
/Skovgaard
I have a fact table and a date table connected to each other. Using a slicer in Power Pivot, I want to show for example the last 13 months, based on the month selected in the slicer.
I have searched and searched the internet, all solutions I find is for Power BI. Many of those have I tried in Power Pivot, without any luck.
Is it even possible to get this to work in Power Pivot?
If so, can you help with the DAX code or refer to an article that describes this?
/Skovgaard
