Anyone was able to resolve this? I have a similar issue?

Thanks John

This helped...

CASE WHEN Week_No = (Select MAX(Week_No) FROM CTEfinal) THEN 'Week4'

WHEN Week_No = (Select MAX(Week_No)-1 FROM CTEfinal) THEN 'Week3'

...

I should have ben a bit specific. Here... Instead of directly renaming , Can we say , The max week number is week4 and then max - 1 is...

Thank you Lynn

As mentioned

It could be /dev/Mywork/deailsbyWork

or /dev/MyTeam/deailsbyTeam

or /dev/MySubgroup/deailsbySubgroup

Outcome

Mywork

MyTeam

MySubgroup

So if I work on Power BI desktop ? I will need SharePoint 2013 to publish the reports for internal use? As I do not want to publish it on...

Guess I figured out.. An inner join helped

If you are getting the total in a table then try adding a text box in a footer and reference the value in that table cell.

Example.

=Reportitems!Textbox6.value

Should typically work if its a date datatype.

This helped me..

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-n,0))

FROM (VALUES(0),(1),(2))x(n)

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-1,0))

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-2,0))

Glad you pointed that first format did make a difference.

Thank you!

That helps.

Thanks

Just past 3 months. I am not building a table

Something like this SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) .

But how to get for Dec and Nov?