Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
Help me with DAX For,
For Fourth Column,
Row 1 - Month 1, (125679.78/168) = 748.09
Row 2 - Month 2, (58364.12/184) = 317.20
Row 3 - Quarter,
I want ((125679.78/168) + (58364.12/184) )/DISTINCTCOUNT(Month)= 1065.29
Also,
I want last two months data alone. Currently Month 1 and Month 2 are Last two Months. When Month 3 data gets updated, Month Column must cotain Month 2 and Month 3 and Quarter ( with respect to Last two Months).
Thanks in Advance,
Sowmiya
Solved! Go to Solution.
@Sowmiya ,
You may try Visual level filters and take a look at this post.
@Sowmiya ,
You may try Visual level filters and take a look at this post.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |