Creating a Meaure to calculate the age of a bill in days based on Today's date and Bill Issue Date

[Joseph_Hchaime]

Hi,

I am trying to create a measure in a separate "measures"table that would calculate the age of an invoice in days based on today's date and the bill issue date. 

My issue is, the data is hosted in an sql server on the cloud so I can't change the schema. i.e. I can't add columns. So i'm trying to create a measure within power bi to calculate it. However, there is no relationship between the Bills table and the "Basic Measures" table that I created within PowerBI to store ALL the calculations I need. The data is refreshed automatically via gateway when I publish so I am only using powerbi desktop to develop the dashboards. 

[Fowmy · Accepted solution]

@Joseph_Hchaime 

If you connect to your Bills Table from Desktop, you can create the following measure to calculate the age of your invoices and store it in your local model; the composite model supports the same. This measure doesn't require a relationship between the Measure Table and the Bills Table.  

Age Measure:

Invoice Age = 
IF(
    HASONEVALUE( BillsTable[Invoice] ),
    INT( TODAY() - MAX( BillsTable[Bill Issue Date]) )
)