Forum Discussion
Rolling 12 months data
Anonymous
I see your requirement now, to explain the dax to get last 12 month, please see this example pbix. And change the return expression to Count().
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi parry2k ,
https://docs.google.com/spreadsheets/d/1lQI0l-Ahz30XkgPx7jABx_Cy8V9usJb6AJzelZX04PI/edit?usp=sharing
This is my sample dataset.
So, basically I have a dataset that contains :
A- it is a primary key contains several IDs
B - Date time stamp (mm/dd/yyyy) format
C - this contains 2 types of option yes or no
D- contains 4 different products (toy , train , bus , car )
Also, I have made a DATE TABLE in POWER BI.
Basicall my requirement is , I have made a slicer from my DATE TABLE in my report , so I want whenever i select a date from my slicer, then I want to display the count of my IDs (from column A ) of one year back on a line chart. (Also, due to some UI Constraint i can't use relative slicer , i just have the option to select a single date from the DATE TABLE slicer)
For eg: If I select 5 may 2020 in DATE TABLE slicer, then I want to display the count of IDs ( from column A ) in a line chart , from MAY 2019 to APRIL 2020 (Also, due to some UI constraint , I don't have the option of using the relative date slicer, I just have the option of using the normal date slicer)
I hope you understand my problem statement.
Thanks !
Anonymous
I see your requirement now, to explain the dax to get last 12 month, please see this example pbix. And change the return expression to Count().
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.