Forum Discussion

Shloka_Lakhani's avatar
Shloka_Lakhani
Frequent Visitor
2 years ago

How to create dynamic Pivot table

Hello All,

I want table like this

                  jan |       feb |     march |         total |     YTD
GBV $123,456 | $56783 | $842567 | $1022806 | $206754
Bookings   23  |        65 |            56 |           144 | 50

how to make it in powerbi using pivot or measure?

I have tried measure like:
company_kpi_booking = IF(HASONEVALUE(booking_table[Matrix]),
SWITCH(SELECTEDVALUE(booking_table[Matrix]),
"2024 Actual",[C_current_year_booking_count],
"2024 Goal",[C_booking_target],
"2023 Actual",[C_prior_year_booking_count],
"% of Goal",FORMAT([C_booking_goal%], "#0.00%")
)
)

but it shows only first measure's value as respective all rows. 
Mean it is only shows total column and bifurcate  by month as i have put month in column field on matrix.


 

I want to add one more column at last of total.

1 Reply

  • nareshr89's avatar
    nareshr89
    Helper II
    2 years ago

    If Month is coming from Data table it might not be possible, but if you have a Dim_table with Month Names alone then you can try by using IF condition and adding a new row along with Month names something like YTD or TOTAL. Also, what is the difference between YTD & TOTAL in your view.