Hi Thank you for the response , I am looking for 3 values based on the defined percentages and the sum of 3 numbers should tally at the end to...

Hi, The query you have sent me will give Last Year Week Number , I need something like .. if today's week is 202001 then i need previous week as...

• This reply was modified 5 years, 3 months ago by Steve Dell.

I even tried to use the below code as example but no luck

CALCULATE (

COUNT ( ticketData[CreateDate] ),

FILTER (

ALL ( ticketData ),

ticketData[CreateDate] <= MAX ('Date'[date] )

)

)

--Fact Table with Actaul_Date, Received, Vendor columns
SELECT  '20190225',  '3109.67',  '10256'   UNION ALL
SELECT  '20180614',  '3103.09',  '10256'   UNION ALL
SELECT...

Actual_DateReceivedVendor
201804250        10256
201805023128.57        10256
201806143103.09        10256
201808023120.19  ...

If you Notice the image you will find that the 201807 , 201810, 201812 as Zero's.

The Rolling 12 Months should calculate as below respectively

201807 --- 16272.19

201810 ---  23932.24

201812 --- 23677.54

its a SSAS Tabular project

• This reply was modified 6 years, 5 months ago by Steve Dell.

can you post your code here so that we can look at it

Thank You and from next time i will follow in having the DDL statements pasted.

Yes the data is very messy . I need to delete or need to consider...

Log in to SSMS as windows user and attach the DB that should resolve Read Only Marked DB issue if you are moving mdf and ldf files from other machines...

To be more specific .. I make huge transactions in database like delete and Insert and Update. Right after this transactions i Shrink the Database and take Transaction log back...