March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
morning all
believe it or not, i did not find the solution here...:)
i have a Clustered Column chart with values forlast 6 months , based on "SignatureDate". to get these values, I use a filter on SignatureDate for the last 6 months.
I created a measurement to get the same numbers last years
@DavidM06 Here are the two suggestions for your problem.
Suggestion 1: Remove .[Date] from SAMEPERDIODLASTYEAR and keep like this
Hi @DavidM06 ,
You can use the ALLEXCEPT function in your LY measure to ignore the filter on SignatureDate. Here's an updated version of your LY measure:
LY = CALCULATE(
SUM(Haraka[TCV]),
SAMEPERIODLASTYEAR(CRM[DateSignature].[Date]),
ALLEXCEPT(Haraka, Haraka[SignatureDate])
)
This measure will calculate the sum of TCV for the same period last year, but it will not be affected by the filter on SignatureDate.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Stephen solution seems to be the solution, but i get some errors
i use the following formula
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
89 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |