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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
arvindyadav
Post Partisan
Post Partisan

how to show drop in cost between 2 days in power bi

Hi Team,

 

How to show the drop in cost between 2 days in power bi. i.e,

Drop in cost..PNG

 

In the above image, you can easily see the drop in the cost. for example, The AM Prakash spend $11740.57 at 3/18/2019 but at 3/19/2019 he spends $7506.94 only so how can I Display YES  or No column when the drop happens or just color it if the drop happens between the date.

 

Thanks,

Arvind

 

1 ACCEPTED SOLUTION
rocky09
Solution Sage
Solution Sage

Is this you wanted?

create a custom column and use below.

 

Drop# = IF(Table1[3/19/2019] < Table1[3/18/2019],"↓","↑")

View solution in original post

1 REPLY 1
rocky09
Solution Sage
Solution Sage

Is this you wanted?

create a custom column and use below.

 

Drop# = IF(Table1[3/19/2019] < Table1[3/18/2019],"↓","↑")

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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