Forum Discussion

NelsonPay's avatar
NelsonPay
Frequent Visitor
3 years ago

How to create a conditional

Good afternoon,

 

I have the following table

I want to create a conditional in which if the total approved amount is more than 50 and is Dinner subtract 50(day limit dinner) if the value is less keep it 0 and if the total is more than 30 and is luch subtract 30(day limit luch) if the total is less kee ipt 0. I have the following formula:

 

IF('Global Meals'[Total Approved Amount USD]>=0.1,IF('Global Meals'[Total Approved Amount USD]>=20,'Global Meals'[Total Approved Amount USD]-[Day Limit Breakfast],IF('Global Meals'[Total Approved Amount USD]>=30,'Global Meals'[Total Approved Amount USD]-[Day Limit Luch],IF('Global Meals'[Total Approved Amount USD]>=50,'Global Meals'[Total Approved Amount USD]-[Day Limit Dinner],IF('Global Meals'[Total Approved Amount USD]>=10,'Global Meals'[Total Approved Amount USD]-[Day Limit Snacks],0)))))
 
How can calculate in a way each formula can be with each subtype.
 
Best regards,
Nelson Pay
General Comment
Need Help
Tips and Tricks
Tutorial Requests

1 Reply

  • markeymark25's avatar
    markeymark25
    Regular Visitor
    3 years ago

    I would create a conditional column under "Add Column" in Power Query Editor.  

     

    There you can spell out your conditions.