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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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