Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
reibalboaOMG
Helper I
Helper I

percentage by last week blank

Hi Everyone,

I'm having a problem on my formula

reibalboaOMG_0-1678413823772.png

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

reibalboaOMG_1-1678413930938.png

here is my formula 

percentageforsoc = IF(ISBLANK([lastweekcpm]), BLANK(), ([lastweekcpm]-[thisweekcpm])/[lastweekcpm])
if the date changes the lastweekcpm turns to blank,
reibalboaOMG_2-1678414407977.png

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

1 ACCEPTED SOLUTION
andhiii079845
Solution Sage
Solution Sage

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.  🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

7 REPLIES 7
reibalboaOMG
Helper I
Helper I

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

please reach me if you're having difficulty in accessing

reibalboaOMG
Helper I
Helper I

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

This will be great! 🙂 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

Upload it via onedrive or dropbox and share the link 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




reibalboaOMG
Helper I
Helper I

Hey @andhiii079845 

here's my lastweekformula

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

reibalboaOMG_0-1678669190209.png

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 reibalboaOMG_1-1678669370462.png

postimpcpm: 

Postimpcpm =
1000 * DIVIDE(SUM('Template (2)'[Cost/Post]), SUM('Template (2)'[Post Impression]))
andhiii079845
Solution Sage
Solution Sage

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.  🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.