cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Rolling = Real + BGT

Hello,

I´m trying to calculate only a a Real + Budget.

The formula is = If( [Real]<>Blank();[REal];[BGT]

It gives me month to month what i want.

The Problem is in the End ( The sum is Wrong). And if i make a YTD of it, it goes only to where i have Real Data..

Here is a Picture of it. Rooling PDV shoud be  = 9313K not 6.266K.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Rolling = Real + BGT

Hi,

I removed the data field from the row labels and dragged Year and Month Name field from the DATA Table.  I modified the Rolling PDV formula to

`=if(HASONEVALUE(DATA[MonthName]),if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv]),SUMX(SUMMARIZE(DATA,[MonthName],"ABCD",if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv])),[ABCD]))`

Here's a screenshot

11 REPLIES 11
Frequent Visitor

## Re: Rolling = Real + BGT

Hi,

excuse me but i don't have solution but i would like to create a message and how to post an image in a post (the insert image option input "source" ?

Thanks

Frequent Visitor

## Re: Rolling = Real + BGT

Ctrl +printscreen . Save and post
Super User

## Re: Rolling = Real + BGT

Hi,

your question is not clear.  What is 9313?  Where did that come from?

Frequent Visitor

## Re: Rolling = Real + BGT

9313K Should be the total of Rolling.

 864.175,00 718.271,00 746.611,00 750.538,00 800.788,00 770.699,00 813.206,00 802.635,00 770.857,00 758.295,00 753.692,00 763.650,00 9.313.417,00
Super User

Hi,

Frequent Visitor

## Re: Rolling = Real + BGT

do you need the file?

How can i share the file?

Super User

Frequent Visitor

Super User

## Re: Rolling = Real + BGT

Hi,

I removed the data field from the row labels and dragged Year and Month Name field from the DATA Table.  I modified the Rolling PDV formula to

`=if(HASONEVALUE(DATA[MonthName]),if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv]),SUMX(SUMMARIZE(DATA,[MonthName],"ABCD",if([Real n Pdv]=Blank(),[BGT(JL)],[Real n Pdv])),[ABCD]))`

Here's a screenshot

Announcements

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 131 members 1,774 guests
Recent signins: