Forum Discussion
Comparison with the previous month using Power Bi
Hi
I have 3 fields Period, Bucket, Ecmployee code.
Scenario: here 2 months period, it is compare with previous Month.
Aug-Red (102)
Sep-Amber (102) based on Employee code equal to then display Employee count in below output. and both period green to green it is come ot required.
Period Bucket Employee Code
Aug-2018 Red 102
Aug-2018 Amber 105
Aug-2018 Green 223
Period Bucket Employee Code
Sep-2018 Amber 102
Sep-2018 Green 105
Sep-2018 Red 223
output:
when select Sept Period filter: Red to Amber, Amber to green, Red to green
Aug - Sept- Employee Code - equal -- display Count.
How to create a cal?
1.add column "netxMonth" in table
nextMonth = DATEADD('table'[Period];1;MONTH)2. lookupvalue and concat
bucketNexMonth = IF(ISBLANK('table'[nextMonth]);BLANK();'table'[Bucket]&" to "&LOOKUPVALUE('table'[Bucket];'table'[Employee Code];'table'[Employee Code];'table'[Period];'table'[nextMonth]))try this
1 Reply
1.add column "netxMonth" in table
nextMonth = DATEADD('table'[Period];1;MONTH)2. lookupvalue and concat
bucketNexMonth = IF(ISBLANK('table'[nextMonth]);BLANK();'table'[Bucket]&" to "&LOOKUPVALUE('table'[Bucket];'table'[Employee Code];'table'[Employee Code];'table'[Period];'table'[nextMonth]))try this