topic Re: Cohort Analysis Help in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353735#M125968 <P>You need to be more clear with what data you have already loaded and what the business logic is. Please provide a table of what you are loading into power BI, the business logic (not excel), and then an example.</P> Thu, 27 Jul 2023 16:11:54 GMT AnthonyGenovese 2023-07-27T16:11:54Z Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353701#M125964 <P>I have been struggling to determine how to calculate the denominator values in the attached examples. Getting the Cohort data and Numerators are easy but just cant figure out the denominator to get the right percentages. Any help would be greatly appreciated. In the end I am trying to replicated the percentages matrix.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P> Thu, 27 Jul 2023 15:42:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353701#M125964 Anonymous 2023-07-27T15:42:49Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353719#M125965 <P>Where does the denominator come from?</P> Thu, 27 Jul 2023 15:55:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353719#M125965 AnthonyGenovese 2023-07-27T15:55:07Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353731#M125967 <P>The denominator is a calculation of a formula&nbsp;</P><P>&nbsp;</P><P>SUM(OFFSET($D$105,-$D128,0):OFFSET($D$105,-MAX($D129,D$130)-1,0)) = 2023 month 0 cohort value 628</P> Thu, 27 Jul 2023 16:08:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353731#M125967 Anonymous 2023-07-27T16:08:22Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353735#M125968 <P>You need to be more clear with what data you have already loaded and what the business logic is. Please provide a table of what you are loading into power BI, the business logic (not excel), and then an example.</P> Thu, 27 Jul 2023 16:11:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353735#M125968 AnthonyGenovese 2023-07-27T16:11:54Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353758#M125970 <P>I don't see anyway to attach a file to provide you the raw data.&nbsp;</P> Thu, 27 Jul 2023 16:23:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353758#M125970 Anonymous 2023-07-27T16:23:40Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353763#M125973 <P>Just provide an example using the table feature in the post reply</P> Thu, 27 Jul 2023 16:25:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353763#M125973 AnthonyGenovese 2023-07-27T16:25:34Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353775#M125975 <TABLE border="1"><TBODY><TR><TD>132</TD><TD>37</TD><TD>29</TD><TD>21</TD><TD>28</TD><TD>25</TD><TD>23</TD><TD>23</TD><TD>22</TD><TD>15</TD></TR><TR><TD>399</TD><TD>135</TD><TD>93</TD><TD>70</TD><TD>68</TD><TD>61</TD><TD>59</TD><TD>60</TD><TD>55</TD><TD>49</TD></TR><TR><TD>393</TD><TD>184</TD><TD>138</TD><TD>120</TD><TD>98</TD><TD>91</TD><TD>83</TD><TD>86</TD><TD>80</TD><TD>66</TD></TR><TR><TD>296</TD><TD>142</TD><TD>129</TD><TD>111</TD><TD>100</TD><TD>91</TD><TD>87</TD><TD>77</TD><TD>80</TD><TD>76</TD></TR><TR><TD>177</TD><TD>108</TD><TD>94</TD><TD>83</TD><TD>80</TD><TD>70</TD><TD>70</TD><TD>64</TD><TD>65</TD><TD>62</TD></TR><TR><TD>263</TD><TD>132</TD><TD>123</TD><TD>123</TD><TD>108</TD><TD>100</TD><TD>92</TD><TD>90</TD><TD>85</TD><TD>90</TD></TR><TR><TD>400</TD><TD>271</TD><TD>237</TD><TD>226</TD><TD>220</TD><TD>217</TD><TD>190</TD><TD>196</TD><TD>181</TD><TD>173</TD></TR><TR><TD>779</TD><TD>558</TD><TD>503</TD><TD>477</TD><TD>448</TD><TD>423</TD><TD>421</TD><TD>363</TD><TD>296</TD><TD>259</TD></TR><TR><TD>628</TD><TD>344</TD><TD>264</TD><TD>169</TD><TD>102</TD><TD>45</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 27 Jul 2023 16:33:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353775#M125975 Anonymous 2023-07-27T16:33:50Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353776#M125976 <P>This is an example of&nbsp; the data that I am using and represents the numerator part of the equation. I am not that familiar with the OFFSET function in Excel and having a nested OFFSET inside an offset is thowing me off on how the denominator is being calculated.&nbsp;</P> Thu, 27 Jul 2023 16:33:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353776#M125976 Anonymous 2023-07-27T16:33:58Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353777#M125977 <P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD><TD>132</TD></TR><TR><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD><TD>399</TD></TR><TR><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD><TD>393</TD></TR><TR><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD><TD>296</TD></TR><TR><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD><TD>177</TD></TR><TR><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD><TD>263</TD></TR><TR><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD><TD>400</TD></TR><TR><TD>779</TD><TD>779</TD><TD>779</TD><TD>779</TD><TD>779</TD><TD>779</TD><TD>779</TD><TD>695</TD><TD>624</TD><TD>546</TD><TD>466</TD></TR><TR><TD>628</TD><TD>517</TD><TD>398</TD><TD>279</TD><TD>154</TD><TD>78</TD><TD>162</TD><TD>233</TD><TD>311</TD><TD>391</TD><TD>446</TD></TR></TBODY></TABLE> Thu, 27 Jul 2023 16:35:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353777#M125977 Anonymous 2023-07-27T16:35:24Z Re: Cohort Analysis Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353778#M125978 <P>This is the expected outcome for the denominator&nbsp;</P> Thu, 27 Jul 2023 16:35:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cohort-Analysis-Help/m-p/3353778#M125978 Anonymous 2023-07-27T16:35:30Z