Hi,
I have the following query which is also a table. I am thinking to use CALCULATE as a measure in Power BI report, but I don't know how to reference different row in the query by situation?
For example, when I create a measure called "2025 control budget", I would like combine two set of data, Actual cost data will come from a query which any cost before and include 2024 Dec data, then forecast cost data will come another query which will include cost info from Jan 2025 and onward. I plan to create four measures as listed under Name column.
Can you please provide me some suggestions? Thanks,
I have the following query which is also a table. I am thinking to use CALCULATE as a measure in Power BI report, but I don't know how to reference different row in the query by situation?
For example, when I create a measure called "2025 control budget", I would like combine two set of data, Actual cost data will come from a query which any cost before and include 2024 Dec data, then forecast cost data will come another query which will include cost info from Jan 2025 and onward. I plan to create four measures as listed under Name column.
Can you please provide me some suggestions? Thanks,