Forum Discussion
4Q Rolling Average (Cumulative Average) Include 0 value
Hi Ashish - I tried the formula as doesn't works and result as follows..
Hi,
Share the download link of the PBI file. In that show the problem very clearly.
Hello,
Question - 1 = Table 2 DAX Formula
Date : 30-09-2022 Average 4Q Wrong (highlighed)
Date : 30-09-2023 Average 4Q Wrong (highlighed)
Question - 2 = Table 1 & Table 2
Example : I used 3 years data then 12 Quarter should be fixed incase no data then zero value in 'date' and all other columns
Both tables 12 rows fixed.. You can check while changing filter
PBIX File:
https://drive.google.com/file/d/1rcyzr51WAq74yNUbIV81CjPqhBlYYyAN/view?usp=drivesdk
I do not understand your question at all. Furthermore, the link takes me to a sign-in page.
Hi Ashish - I shared PBIX File in Google drive and don't know how to share other way around.
Highlighted blue color portion i'am trying to reach in Power BI. Thanks!