Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago

Last Week comparison not working properly

Hi I have created a measure to compare the current week value with last week value. Its working fine in some pages, but all.   X_Test_Measure = VAR _LW_Price = LASTNONBLANKVALUE( DATEA...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

vijayvizzu , Make sure Cw_no is coming from the date table .

 

or

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

refer if needed

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

  • vijayvizzu's avatar
    vijayvizzu
    Helper III
    5 years ago

    Thank you, but i can't able to upload any document as my PC doesnt allow me to upload anything