percentage by last week blank

[reibalboaOMG]

Hi Everyone,

I'm having a problem on my formula

here in my dashboard i have week 2 and 3

both weeks are showing correct % but when i switch on a duration it goes blank

here is my formula 

percentageforsoc = IF(ISBLANK([lastweekcpm]), BLANK(), ([lastweekcpm]-[thisweekcpm])/[lastweekcpm])

if the date changes the lastweekcpm turns to blank,

so that's why the cards go blank, is there a way for me to show it? and dont summarize the %

thanks for the response

[reibalboaOMG]

@andhiii079845 here's the link Project Lift off 2.pbix,

please reach me if you're having difficulty in accessing

[reibalboaOMG]

@andhiii079845 since it's a dummy data that i'm using do you want the pbix file?

[andhiii079845]

This will be great! 🙂 

[reibalboaOMG]

Where can i send the pbix, email?, i'm trying to attach the files here but the file was not supported for attachment

[andhiii079845]

Upload it via onedrive or dropbox and share the link 🙂

[reibalboaOMG]

Hey @andhiii079845 

here's my lastweekformula

lastweekcpm = CALCULATE([Postimpcpm] ,ALLSELECTED('Template (2)'),'Template (2)'[weekrank] = MAX('Template (2)'[weekrank])-1)

thisweeks formula 

thisweekcpm = CALCULATE([Postimpcpm] ,ALLSELECTED('Template (2)'),'Template (2)'[weekrank] = MAX('Template (2)'[weekrank]))

percentageforsoc = IF(ISBLANK([lastweekcpm]), BLANK(), ([lastweekcpm]-[thisweekcpm])/[lastweekcpm])

and the 

postimpcpm: 

Postimpcpm =

1000 * DIVIDE(SUM('Template (2)'[Cost/Post]), SUM('Template (2)'[Post Impression]))

[andhiii079845 · Accepted solution]

Hi, 
You have to show us the involved tables, columns and measures. I think a upload (via ondrive, dropbox) with a example without senstive data will be the easist way.  🙂