Forum

Francis Ong
@zchase
Eminent Member
Joined: Aug 26, 2020
Topics: 6 / Replies: 12
Reply
RE: How do i calculate the amount by taking the value from an earlier date?

I am exploring Power Bi and using measure to calculate the value from the native currency to USD currency. I want to retain the existing exchange rate...

5 years ago
Forum
Reply
RE: Different results when moving fields around in PivotTable

I solved the problem by unchecking the Filters option (Include filtered items in totals) They are showing more information that is not necessa...

5 years ago
Forum
Reply
RE: How to get cumulative total with multiple criterias?

If the budget amount ends on Mar, what do i need to add to the measure remove the remaining months so that the RT Line Chart will show correctly for B...

5 years ago
Forum
Reply
RE: How can i create a measure that can pull out value that is a sum of column that is groupby one or more criterias?

Hi, Please find attached sample. I have not created the measure since it is giving me wrong result. If you refer to the sample, commit amount is...

5 years ago
Forum
Reply
RE: How to get cumulative total with multiple criterias?

The result seems to be not correct when i start to add more data. The additional data ends on 20-Aug-2020. It is not adding the August tota...

5 years ago
Forum
Topic
Forum
Replies: 1
Views: 61
Reply
RE: How to get cumulative total with multiple criterias?

You are correct that i have two separate tables for budget and commit and i am using date table. I created a sample file for this and i am still no...

5 years ago
Forum
Reply
RE: How to get cumulative total with multiple criterias?

On that graph which i have generated, is there a way to cut the line based on the availability of the transactions? For example, Budge...

5 years ago
Forum
Reply
RE: How to get cumulative total with multiple criterias?

Thx alot. Guess i do not need that calculated columns after all. I change Show Values as "Running Total In" against Base field "Month name" fo...

5 years ago
Forum
Reply
RE: How to get cumulative total with multiple criterias?

I am not sure. But i am using the cumulative total to show the graph for budget vs actual. It should also be able to show by total amount in y...

5 years ago
Forum
Topic
Reply
RE: How do i calculate the amount by taking the value from an earlier date?

If i sort by currency before i fill up would that work?

5 years ago
Forum
Page 1 / 2