Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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]) )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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]) )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |