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.
Anonymous than you have to take time to explain your problem with sample data and expected output, there is no way to understand what is the complexity in your problem give the original post.
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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.