Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I am trying to make a comparison dashboard and would like to make some "cards" showing how the company performed in the same period last year. One for the same month last year and one for the same day. When creating the "same day" card, it is important that it is not the same day in like the 30th of August, but instead the same Thursday. Which is why I have used the "-1" in the query below.
Anyways, I can't get it to work. Can anyone help me?
Thanks.
TurnoverSameDayLast year= CALCULATE(SUM(PaymentLog[Amount]),PaymentLog[inheritanceTypeName]="tenant_search_profile", SAMEPERIODLASTYEAR('Date'[Date].[Day]-1))
Solved! Go to Solution.
Hi@ aletho
You can try to use this formal, do not use 'Date'[Date].[Day] in your measure
TurnoverSameDayLast year= CALCULATE(SUM(PaymentLog[Amount]),PaymentLog[inheritanceTypeName]="tenant_search_profile", SAMEPERIODLASTYEAR('Date'[Date]))
Best Regards,
Lin
Hi@ aletho
You can try to use this formal, do not use 'Date'[Date].[Day] in your measure
TurnoverSameDayLast year= CALCULATE(SUM(PaymentLog[Amount]),PaymentLog[inheritanceTypeName]="tenant_search_profile", SAMEPERIODLASTYEAR('Date'[Date]))
Best Regards,
Lin
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |