Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Help needed!
Selected Parameter = maxx(filter('Date Value', 'Date Value'[Date Value Order] = SELECTEDVALUE('Date Value'[Date Value Order])), 'Date Value'[Date Value Fields])
This returns the name of selected column in slicer created using field parameter. I have 4 columns in slicer - "LAST_OPPORTUNITY_CHANGE_DT", "MBR_PGM_CREATE_DT", “MBR_PGM_ENROLL_DT","OPPORTUNITY_CREATE_DT"
Attaching test dashboard snapshot for your reference.
Now based on the selected column name wants to create flag if the particular date of that column falls in last 180 days.
Last 180 days flag = IF([Selected Parameter] > (TODAY()-180),"1","0")
This is giving error, value coming from selected parameter is not considered as column but is considered as text. So it's not matching up with today()-180 days condition.
The value coming from selected parameter is not considered as column but is considered as text. So, it's not matching up with today()-180 days condition. If I directly consider column the formula is working fine.
Please suggest how should I approach this problem.
@Nishant77Goel , Can you share error you are getting
Also try this one as number
Last 180 days flag = IF([Selected Parameter] > (TODAY()-180),1,0)
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 74 | |
| 70 | |
| 39 | |
| 35 | |
| 23 |