Forum Discussion
Excel to DAX
Are those 3 separate tables? How are they related to one another?
This relationship is based on the date, taking the date column for the derived_dimdate and rest coming from the renewal_reporting
You're killing me Nimai123
So for the sample data that you posted, the first two are columns in the left table in your image and the last one is a column in your date table or ?
Please follow the instructions here: Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sample data as text in the same form that it appears in your data. Expected result from sample data. Logic of how to get from a to b.
I have sent you the link for the file to download in Private Message.
Thanks for your patience!
Regards,
To simplify what I need
For TTM RR
FY19-Q4 = 82% Requirement
Renewed+open
29,452,554 FY19-Q1 36,612,309 FY19-Q2 66,404,172 FY19-Q3 62,861,772 FY19-Q4 Total by adding =195,330,807
usd_last_year_acv_converted
38,396,325 FY19-Q1 45,537,908 FY19-Q2 79,395,896 FY19-Q3 73,667,240 FY19-Q4 Total by adding = 236,997,369
195,330,807/236,997,369 = TTM RR = FY19-Q4 = 82%
FY20-Q1 = 84% Requirement
Renewed+open
36,612,309 FY19-Q2 66,404,172 FY19-Q3 62,861,772 FY19-Q4 38,341,826 FY20-Q1 Total by adding= 204,220,079
usd_last_year_acv_converted
45,537,908 FY19-Q2 79,395,896 FY19-Q3 73,667,240 FY19-Q4 45,398,559 FY20-Q1 Total by adding = 243,999,603
204,220,079/243,999,603= TTM RR =FY20-Q1 = 84%
And same for the other periods, but it should only calculate when we have data for the previous 4 Qtrs including itself.
To understand the above statement we are not calculating FY19-Q3 because we have data for FY19-Q3, Q2, Q1 but no data for FY18-Q4
Hope this helps
