Forum Discussion

Pavani's avatar
Pavani
Helper II
3 years ago

Creation Percentage

Hi ,

 

I need to create percentage rating date/ trigger date month wise mentioned month wise count also please help to create percentage in power bi 

I need like 115/ 926 = Percentage 

 

YearMonthCount of Custom field (CSAT Rating Date)Count of Custom field (CSAT Trigger Date)
2023January115926
2023February110888
2023March1061074
2023April1001005
2023May110987
2023June66909
2023July71811
  6786600

 

Custom field (CSAT Rating Date)Custom field (CSAT Trigger Date)
20/Apr/23 14:27:00 CEST4/18/2023 16:30
20/Apr/23 13:18:00 CEST4/20/2023 13:16
20/Apr/23 09:46:00 CEST4/20/2023 9:00
19/Apr/23 13:23:00 CEST4/19/2023 13:19
19/Apr/23 16:25:00 CEST4/19/2023 16:24
19/Apr/23 13:44:00 CEST4/19/2023 13:42
17/Apr/23 13:33:00 CEST4/17/2023 11:57
18/Apr/23 10:25:00 CEST4/18/2023 10:01
18/Apr/23 11:12:00 CEST4/18/2023 10:58
18/Apr/23 08:10:00 CEST4/17/2023 17:12
17/Apr/23 16:51:00 CEST4/17/2023 16:46

Below one correct for percentage month wise 

 

Need Help

2 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Pavani ,

    try this measure,

    Percentage (%) = DIVIDE(MAX('Table'[Count of Custom field (CSAT Rating Date)]),MAX('Table'[Count of Custom field (CSAT Trigger Date)]))