Power Bi Report YAGO measure not updating in same time period

[juliepoole]

Hi All,

I would be really grateful if you could help as I can't share my Power Bi report until this is fixed.   I have a Power Bi report which is updating correctly in all measures other than YAGO calculations.  I will provide an example of what is happening.

February MTD - Feb 1st to Feb 13th as at Feb 15th refresh

Correct Sales MTD measure, YAGO MTD measure correct

February MTD - Feb 1st to Feb 14th as at Feb 15th refresh

Correct Sales MTD measure, YAGO MTD measure showing data for the whole month of February 

Hence my YAGO MTD measure is presenting the correct data but only when the date filter is two days before the refresh date.  When the date filter is the day prior to the refresh date the YAGO MTD data is showing data for the whole month and not the MTD portion.

FYI - I have set up my date calendar table based on the fact table latest dates from the data warehouse (if this is relevant).  

Thanks for your support. 

[juliepoole]

@v-yiruan-msft 

Thank you and apologies for the delay in replying.   I have reviewed the solutions provided and I am still experiencing the same problem.   

Here is a table which presents the issue.   In Power Bi for a date range from February 1st - 21st YAGO sales are showing as $3.2m but when I exported the daily sales into Excel and total YAGO from last year I get only $2.394m .  The $3.2m is for the full month of February so I am not sure why it is totalling incorrectly - it is ok when I export the data from February 20th but not the day before the refresh.

Please advise how I can share data.

[parry2k]

@juliepoole can you share measures?

[juliepoole]

Hi @parry2k 

Please see the measures used below:

Booked Sales = SUM(vw_fact_booking[net_total_amt])

Booked Sales YAGO = CALCULATE([Booked Sales],SAMEPERIODLASTYEAR(datetable[Date]))

Thanks for responding.  Let me know if you need any further information.

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

=SUMX(VALUES(datetable[Date]),[Booked Sales YAGO])

Drag it to the visual.

[juliepoole]

Thank you so much.  This is now working.  Such a relief!

[Ashish_Mathur]

You are welcome.

[v-yiruan-msft]

Hi @juliepoole ,

Please check whether there is any filter or slicer affect on the result in your report. In addition, please review the solution in the below similar threads and check whether can help you resolve the problem.

SAMEPERIODLASTYEAR not working as expected

TOTALYTD with SAMEPERIODLASTYEAR not working as expected

sameperiodlastyear bug problem

If the above one is not working, please provide some sample data and the relationship setting between fact table and data table. Thank you.

Best Regards