Lookup does not work

Frequent Visitor

4 years ago

I do understand, but it is company data and confidential, sorry.

FOT is an abbreviation for First Online Time which defines for certain revenue streams the start of revenue recognition. There are several columns (FOT Adjusted, FOT_Convention) to adjust this date so it fits the needs - hope this helps. This file is generated each month and then imported into PowerBI.

I do have License Type Perpetual, Flex and Other, Product Type Core Version, Core Version - Other, Module and Other. I do need a Core Version or Core Version Other at a minimum, then the customer can add Modules at any time, but the module follows the Core Version in terms of revenue recognition. The DAX formula I try to create should calculate this shorter revenue recognition period for modules added later in time. The Licenses (Perpetual and Flex) are split in License and Support, Support is deferred over 12 months.

I continued to work on my formula, but still do not get the result I want:

VAR boolean_fot_cv = Calculate(MAX(IDL_Total[FOT_Convention]), Filter(IDL_Total,IDL_Total[serialNumber]<>BLANK() && IDL_Total[Product type] = "Core Version" ))

VAR boolean_fot_module = Calculate(MIN(IDL_Total[FOT_Convention]), Filter(IDL_Total,IDL_Total[serialNumber]<>BLANK() && IDL_Total[Product type] = "Module" ))

I am happy to share an excel file with you and any DAX Command for a calculated column/measure you need. But I would need to delete certain data (Customer Name, Product Name etc.) which I guess yo do understand.

Regards

Angie

Forum Discussion

Related content

Lookup formula not working

Onedrive automatic update does not work

Lookup help

Refreshing semantic model does not work

Power BI / Salesforce Report Connector - Does it even work???