Forum Discussion
Using IF to multiply columns according to date
Anonymous missing info about your model, but let's try (assuming you have all the columns in one table):
In case yor need a calculate column than adjust this code to your model needs:Column = Table[Quantity] * IF( YEAR('Table'[Date]) < 2022, 10, Table[Cost])
In case it's a measure go with this:Measure = SUMX( 'Table', Table[Quantity] * IF( YEAR('Table'[Date]) < 2022, 10, Table[Cost]) )
In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂
the thing is the data is confidential i will try to explain.
i have 2 tables. both contain sales per day and only table one contains the cost.
i need to find the cost per day which is cosst*sales per day, but if date <2022 it was 10$ fixed, but after 2022, i have a different cost everyday and have to multiply the cost column with the sales per day column but its in different table. i created a realationship between the tables which is the date is the rlationship
Community ChampionAnonymous still not sure 😞
Can you maybe create a fake data that you could upload as tables here, and also show exactly what is the relationship (who is the one side who is the many)
ok i will try but im fairly new here so how do i create a table here?
- SpartaBI
Anonymous you can create it in excel and just copy paste here.
P.S. I will maybe be able to get to only tomorrow but we'll try today. Already late evening here 🙂The relationship is date i managed the relationship as the date
Table 1 Table 2 date cost sales cost per day date sales cost per day 10/5/2021 "cost is fixed at 10 because <2022" 70 "=" cost *sales per day 30/4/2021 70 "=" table1[cost] *sales per day 10/20/2021 40 9/29/2021 67 1/5/2022 3 21 1/5/2022 50 9/4/2022 6 68 9/4/2022 190 9/5/2022 7 55 9/5/2022 90 9/6/2022 3 65 9/6/2022 55 9/7/2022 4 89 9/7/2022 120