Forum Discussion
Helper IDAX - Percentile Calculation at different granularity
Helper IVahidDM that worked partially but it appears the filter for month is also being removed.
I need the percentiles to be reset for every month/year
Super UserDo you have any Date table? what is the source of that Month Column?
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/
- 2366
No, I do not have an explicit Date table. I am using the inbuilt date hirearchy "Month" column in the visual
- VahidDM
So It would be better to add a Date table to your model then it will be easier to find a solution.
How to create a Date table:https://www.vahiddm.com/post/creating-calendar-table-with-3-stepsCan you share a sample of your PBIX file after removing sensetive data?
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/- 2366
I have shared it in DM. I have applied the date table now