Forum Discussion
3 month rolling -text type date
Hi,
I posted this a month ago. However, I realized that I need to use the "month.year" column in text format.
Link: https://community.powerbi.com/t5/Desktop/3-month-rolling-count/td-p/1642549
I have "month.year" column in text format and in a different table. I have type also in another table. I use "type" and "month.year" from its own table as slicers. Based on the selection, I want to count the number of records for the last 3 months. You can download the files. the measure below works when the month selection is in date format. However, I need to use it in text format since some other pages changes when I change the type format.
Thanks in advance.
6 Replies
- lbendlin
Super User
Use a proper calendar table that includes numeric and textual representation for weekday names, Months names and numbers etc. Switch off the auto date/time function and use your own calendar table.
- IF
Post Prodigy
Hi,
Is it possible to send me the example? Regards,
- IF
Post Prodigy
Hi,
I uploaded it to: https://www.dropbox.com/s/6hyv9guz6jd9707/q%203m%20rolling%20not%20workingMarch2020.pbix?dl=0
Kind regards,
- v-lionel-msft
Community Support
Hi IF ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- IF
Post Prodigy
Hi,
Thank you very much. I checked it. if I select 06.2020 and type "a", I should count 3 for the values for last 3 months. However, it shows 6.