Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi @Anonymous ,
We can try to use the following measure to meet your requirement:
ChangeInDrillDown =
VAR month1 = 'Fact - Backlog Cases'[# of Backlog Unscheduled Cases (End of Month)]
VAR quarter1 = 'Fact - Backlog Cases'[# of Backlog Unscheduled Cases (End of Quarter)]
RETURN
IF (
ISFILTERED ( 'Hierarchy - Fiscal Calendar on Open Date'[FiscalFYMonth] ),
month1,
quarter1
)
Best regards,
I found solution and evrything works correctly.
Thankyou!!
Now I have to do other formula but with different characteristics. Is it Okey if I explained it here so we kkep contact or I make a new post.
Regards,
Alejandro
Hi @Anonymous ,
Glad to hear that you have resolved your problem. If it does not contain any confidential information,could you please kindly share the solution you find so that it can benefit more users here? If you have any other questions about this scenario , please kindly ask here and we will try to resolve it.
Best regards,
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |