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 4 years, 5 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 5 years, 7 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...