Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello Everyone,
I have a table with issues and percentage for current month and average but i do not have any table yet where i can show this avergae is for particular month and for every changing month it should add the month and average of issues automaticaly to that table, can you please help me to get that ?
for example october month avergae is 22.47 and and suppose november it would be 25 then in the table this should automaticaly show that for october it was 22.47 and for nov it is 25
Table 1 | ||||
Issues Name | Percent | |||
Sales | 82.86 | |||
Prod | 21.27 | |||
Eng | 6.06 | |||
Quality | 1.09 | |||
Admin | 1.05 | Average Issues for october | 22.47 | |
Thanks and Regards
@members
Hello @Anonymous
I think I wasnt able to explain better please have a look below and help me
So I have Table 1 created out of data scores like below
Table 1 | |||
Issues | Name&Percent | ||
Sales | 82.86 | ||
Prod | 21.27 | ||
Eng | 6.06 | ||
Quality | 1.09 | ||
Admin | 1.05 | ||
Avg of issues for Sep | 22.47 | ||
In next month Table 1 one will have different value | |||
Issues | Name&Percent | ||
Sales | 85.86 | ||
Prod | 25.27 | ||
Eng | 7.06 | ||
Quality | 1.09 | ||
Admin | 1.05 | Avg of issues for Oct | 24.06 |
So I want to create another table which can store month wise average data based on Table 1 | |||
Average Table | |||
Avg of issues for Sep | 22.47 | ||
Avg of issues for Oct | 24.06 |
Thanks and Regards
Premlata
Hi @Premlatapandey9 ,
I think you can use dynamic title in card visual to show the monthname in card title.
Measure:
Title =
VAR _Current_MonthName = FORMAT(TODAY(),"MMMM")
RETURN
_Current_MonthName
Due to today is 2022/09/30, so the data should in September. When the date be 2022/10/01 (tomorrow) and your data refresh, your total will show October.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |