Conditional based output

[Anonymous]

Hello everyone,

I am trying to calculate output column. Can anyone help me here?

Output = If Type = "Financial Value" and Financial date =< Today then print Realized column value to the output column else blank.

[Mikelytics]

Hi Schree185, 

The following formula should work. 

Output = IF(AND('Table'[Type]="Financial Value",'Table'[Financial Date]<= TODAY()),'Table'[Realized Value],BLANK())

But one thing. In your picture one time the output value was taken for a row with "Saving Value". Is that right? If yes then you may have to adjust the rule.

Best regards

Mikelytics

[Anonymous]

@Mikelytics Hi,

I want to add one more condition . Can you help me with this.

Output = If Type = "Financial Value" and Financial date =< Today then print Realized column value * "allocation percetange" to the output column else blank.

[Anonymous]

I took Saving value by mistake. I am sorry for tht.

[Fowmy · Accepted solution]

@Anonymous 

You can use the following code as a new column:

New Column =
IF (
    Table[Type] = "Financial Value"
        && Table[Financial Date] <= TODAY (),
    Table[Realized Value],
    BLANK ()
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Anonymous]

Hi,

I want to add one more condition 

Output = If Type = "Financial Value" and Financial date =< Today then print Realized column value * "allocation percetange" to the output column else blank.