Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two slicer showing
- Calender Year
- Calender Month (Jan, Jun)
When I select a year and month, the card/table shows me the # of deals contracted.
What I am trying to see in that card/table is; when I select ie.Jun, I want to see the # of deals contracted in previous 3 months (Feb-Mar-Apr)
Here is the formula I put, but it shows blank
Witing for your help
Thank you
Last 90 Days Contracted = if(or(month(SalesDashboard[Contract Date])=SELECTEDVALUE(Calender[Month])-1,or(month(SalesDashboard[Contract Date])=SELECTEDVALUE(Calender[Month])-2,month(SalesDashboard[Contract Date])=SELECTEDVALUE(Calender[Month])-3)),1,0)
Hi @YavuzDuran ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
Best Regards
Lucien
Hi @YavuzDuran ,
Use the following measure:
Last 90 Days Contracted =
VAR _select =
SELECTEDVALUE ( Calender[Month] )
VAR RESULT =
IF (
_select
>= MONTH ( SalesDashboard[Contract Date] ) - 3
&& _select
<= MONTH ( SalesDashboard[Contract Date] ) - 1,
1,
0
)
RETURN
RESULT
If still not work ,could you pls share your pbix file?Remember to remove confident data.
Best Regards
Lucien
Also, the 3 months prior to June are March, April and May. Share more details, if you need more help.
Needs more context (pun slightly intended). Please show your work - is that a calculated column, is it a measure?
Note that you can use || or IN {} instead of nested OR().
Please provide sample data in usable format (not as a picture) and show the expected outcome.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |