I am needing some help with a power bi issue.
I have a report layout that lists the day of the month in each column and then the last 3-month average.
However, the days are dynamic, so when it’s the current month, they only want to see that number of days reflected in the report.
I am not sure how to do this within Power BI. If I create a column for each day of the month, that would solve part of my issue, however, it’s not dynamic.
1 - Monday | 2- Tuesday | 3- Wednesday … | Last3Month Avg | YTD Avg
I am able to accomplish this within SSRS because it allows you to add rows as columns as well as additional columns.
Any help would be greatly appreciated.