Forum Discussion

Earl40's avatar
Earl40
Helper I
2 years ago

Need help creating a table in PowerBi

Hello,   I currently have a PowerPoint table thats manually updated and need to create it in PowerBi.  The goal is to create a table that shows the % of items aged >30 days for the notification typ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Earl40 ,

 

Here are the steps you can follow：

1. Create calculated table.

Main_Table =
var _table1=
CALENDAR(
    DATE(2023,1,1),DATE(2023,12,31))
var _table2=
ADDCOLUMNS(
    _table1,"Year",YEAR([Date]),"Month",FORMAT([Date],"mmmm"))
var _table3=
{"Notification closed aged > 30 Days"}
var _table4=
SUMMARIZE(_table2,[Year],[Month])
return
CROSSJOIN(
    _table4,_table3)

2. Create measure.

Test =
   CALCULATE(
       DISTINCTCOUNT('Data Table'[Item #]),
        FILTER(ALL('Data Table'),
        YEAR('Data Table'[Create Date])=MAX('Main_Table'[Year])&&FORMAT('Data Table'[Create Date],"mmmm")=MAX('Main_Table'[Month])&&'Data Table'[Age]>=30&&'Data Table'[Type]="Notification"))

3. Placement in Matrix Visual.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

  • Earl40's avatar
    Earl40
    Helper I
    2 years ago

    Anonymous  Thanks, quick question which column field from the table should be added. I highlighted the section in the screen shot below.

     

    Thank You