Re: Remove incomplete week

Anonymous · ‎03-21-2019

Hi there,

I am plotting a weekly line chart with daily data. I am trying to not show the latest week's data point if the week is incomplete.

My current solution does not work

Adm WK CY = 
VAR x = year( LASTDATE( MAIN_COR[DATE]))
VAR z = WEEKNUM( LASTDATE(MTDdate[Date]), 1)

Return 
CALCULATE( sum( MAIN_COR[ADM]),MAIN_COR[Attribute] = "Actual", MAIN_COR[Year] = x, MAIN_COR[Wkno] < z)

However, if I replace "z" with the current week number itself, "12", it works.

Where am I going wrong here?

vanessafvg · ‎03-21-2019

@Anonymous have you returned(printed) all your variables to test you are getting what you expecting?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Anonymous · ‎03-21-2019

@vanessafvg Yes if I return the variable z, it gives me "12", the current week number.

vanessafvg · ‎03-21-2019

@Anonymous any chance you can share your pbix?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Anonymous · ‎03-21-2019

I'm afraid I can't, perhaps can you suggest another way to go about doing it? I have included a picture of the line chart I am trying to fix for illustration. Adm WK CY for week 12 is irregular because the week is incomplete. Therefore I want to remove that point.