Forum Discussion
Create conditional column in calculated table
Hi,
Write this calculated column formula in the Date Table
Financial Year = if(month(date[Date])>=7,"FY"&Year(date[Date]),"FY"&Year(date[Date])-1)
Hope this helps.
Good
I'm working in a project company and I have a problem with a report I want to generate based on duplicate operation codes. The source from which I obtain the data is an excel exported from a report that generates records for each of the reasons that cause an offer to be rejected.
The problem is that I want to analyze the offers according to their reason for rejection but there are times when a offer is rejected for more than one reason. This causes two records with the same information to be generated for the same offer for all fields except for the reason for rejection:
| Code | Ground for rejection | Matter |
| ABCD | Price | 214.209 |
| ABCD | Technical offer | 214.209 |
Because of this, when I want to generate a table or graph analyzing the lost offers due to rejection and price, the sums of amounts are incorrect since it counts x2 or x3 amounts of rejected offers... To avoid this, I understand that I would need to create a column that collects only once the amount of several records with the same code, leaving the rest of the records with the same code blank. Something like the "Actual amount" column:
| Code | Ground for rejection | Matter | Actual amount |
| ABCD | Price | 214.209 | 214.209 |
| ABCD | Technical offer | 214.209 |
Does anyone know what function you could use to generate this column?
Thank you very much in advance!
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.