Forum Discussion
Measure with Fixed value and value in time
Hi everyone,
I got the following tables shown in a matrix:
I want to create a measure that calculates the Hours NC +Cost NC/ budget in a specific month. But for some reason when i make the measure it only shows up for the first month. All the other months keep blank. I think the problem lies in the fixed value of budget, and the other values that are connected to a time table. When i add budget into the values of the matrix, for some reason it only shows up in one month and not all the months.
Does somebody have an idea what to do?
It worked when i was trying this with a very basic file. But now i have appended alot a queries and the measure does not seem to work anymore.
Kind Regards,
Daimy
3 Replies
Daimy , How is the budget is connected to the date table. is your value of budget sorted for only one month or day ?
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
you can refer to my blog is value is only stored for date (year end date)
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
amitchandak The budget is a column in the project table. The project table is not connected to the calendar table. budget is therefore not associated with a time. It is a very big file so sharing data is gonna be difficult, because almost everything is sensitive data.
Hi Daimy ,
Sample data is important in your case,so try to create a simple sample with expected output to describe your issue.
Check the blog below:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
