Forum Discussion
Lookup does not work
I prepared the excel sample extract:
I know you do prefer PBIX, but the source file is on sharepoint and I cannot change that data of course.
I did highlight the calculated columns, the column I try to calculate is AU. We can do a screen sharing as well if necessary.
Regards
Angie
sorry, my bad. I changed the settings plus imported the excel into a sample PowerBI file:
https://drive.google.com/file/d/1soJ0IG0gnLW_cndyOPc6HfyehB0DQ-9Y/view?usp=sharing
Just let me know if this is now working.
Thanks.
Regards
Angie
Hi, GracieLeeMonroe
Can you tell me for this formula what do you want to get? Your measure is too messy and I can't see a complete logic from your description, It's hard for me to get started without logic.
the purpose of the calculated column in general is to define the revenue recognition period. A customer acquires the core version at a certain time, and then adds modules if needed. The module has to follow the core version in terms of revenue recognition period, the link is the serial number. Revenue Recognition starts upon FirstOnlineTime (FOT), there are several calculated columns to define the FOT date which should be used for start of revenue recognition, the final one is named "FOT Convention". So a customer purchased a core version in 12/2020 with a FOT Convention date of 01/2021 and in 02/2022 he adds a module to this license. The revenue for the module then should be recognized over 11 months. Hope this makes sense, since this is the overall logic.
With the formulas I just tried to determine those two dates (FOT Convention for the Core Version which should be in the example above 01/2022 and the addition of the module in 02/2022) so I can calculate the difference in months further below.
In the sample data you have, there is one line with an amount of 4.25 and that should be a period of 1 month - if that helps.