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
Here's my sample dataset.
So, I basically have a dataset that contains:
A- is a primary key containing multiple iDs
B - Date stamp format (mm/dd/yy)
C - contains 2 types of yes or no option
D- contains 4 different products (toy, train, bus, car)
In addition, I have created a TABLE OF FECHAs in POWER BI.
Basicall my requirement is , I've done a slicer of my date table in my report, so I want every time I select a date from my slicer, then I want to show the count of my iDs (from column A) from a year ago in a line chart. (Also, due to some UI restriction I can't use relative slicer, I only have the option to select a single date from date slicer)
For example: If I select 5 May 2020 in the TABLE DATE segmentation, then I want to display the ID count (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 to use relative date segmentation , I only have the option to use normal date segmentation)
I hope you understand my problem statement.
Thank you!