Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a Budget table that has a budgeted amount per month of the year.
I am trying to lookup a budget value (table: Budget) for a month to another date table (table: Daily Targets), to calculate a daily budget value. (My budget table only has monthly targets, but I need to obtain daily targets by dividing this value by the number of days)
In my Budget table, I created a column to work out the number of days for that month using:
Solved! Go to Solution.
your month year filed in the budget table is not unique because there are 4 entries for every Month one fore each of your Propertys
if you have the Propert in the Daily targets then concat all thre month year and propert to create a unique ref
if you do not have this filed then you need to find another way to make a uniqe ref
Proud to be a Super User!
Can you provide a PBIX file so that i can review the data,
this error would imply that your unique refrence colunm of month year is not unique
if you upload a file i can review this and try an find the error
Proud to be a Super User!
@AnthonyTilley Sorry, I am quite new; Can you tell me the steps to upload the PBIX file and I will do so?
Thanks!
ypu will need to save the PBIX file to a cloud storage such as onedrive, google drive or drop box and then share the file to public with a link and then post the link in this thread
Proud to be a Super User!
your month year filed in the budget table is not unique because there are 4 entries for every Month one fore each of your Propertys
if you have the Propert in the Daily targets then concat all thre month year and propert to create a unique ref
if you do not have this filed then you need to find another way to make a uniqe ref
Proud to be a Super User!
Ah! makes sense now. thanks!
your welcome
If there is nothing further please mark the topic as solved
Proud to be a Super User!
Do you perhaps have a quick way for me to edit my Daily Target Table so that I create 4 records of each row, and include a new column stating the lodge, so that I can create my unique reference?
ill take a look now
Proud to be a Super User!
okay i have created a table that is a distinct list of proporties in your budget table
i have then changed you Daily targets table to be a combine of your calander and this table to create a row for each merged item in the table
i have then changed your concat formulas to give a unique refrence for the month year colunm and changed the relationship
i have then fixed your lookup colunm in the daily targets table
hope this helps
Proud to be a Super User!
Thanks Anthony! This has really helped.
I added a divide function to my lookup formula, and now I have blanks in my DAILY TARGET Column in my DAILY TARGETS Table, and I am not seeing any logical reason why? Would you know?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |