cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
venunm
Frequent Visitor

Sum of a column with repeating values - DO NOT DISPLAY

‎01-11-2017 07:45 AM

Hi

In the attached how would I not display the sum value 837418.20 for the rest of the days where there are no actual values yet? Please see THE FORMULA BELOW  and you would understand what I am trying to do. Power BI - issue1.PNG

Message 1 of 15
1,829 Views
0
Reply
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support
In response to venunm

‎01-17-2017 04:54 PM

Hi @venunm,

 

>>Hi do you know how you got the 'current' in you formula? and what is dates?

"Current" is the " New Column.Disbursed Advance Amount" column, "Data" field has auto analyzed to date hierarchy.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Message 12 of 15
2,689 Views
0
Reply
14 REPLIES 14

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All