Solved: Power Bi Report YAGO measure not updating in same ...

juliepoole · ‎02-14-2021

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.

Ashish_Mathur · ‎02-21-2021

Hi,

Does this measure work?

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

Drag it to the visual.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

juliepoole · ‎02-21-2021

@Anonymous

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 · ‎02-14-2021

@juliepoole can you share measures?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

juliepoole · ‎02-14-2021

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 · ‎02-21-2021

Hi,

Does this measure work?

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

Drag it to the visual.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

juliepoole · ‎02-21-2021

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

Ashish_Mathur · ‎02-21-2021

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Anonymous · ‎02-17-2021

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