Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi ,
Please I need your help ,
I have 2 tables :
- Cashflows
Fund
EntryDate
Commitment
- ReportingDate
Reportingdate
reportingdate Q-1
these two tables are not linked in my model .
I want to get im matrix this
fund | entrydate | Newcolumn |
New column is based on the value selected in my slicer (slicer contains reporting date )
And I want to get True Or False in Newcolumn if Entrydate is between ReportingDate and ReportingdateQ-1.
I was test many measure but it don't work:
Thanks
Solved! Go to Solution.
NewCommitment = VAR rd = SELECTEDVALUE(ReportingDate[ReportingDate]) VAR rdM1 = PREVIOUSQUARTER(ReportingDate[ReportingDate]) VAR filteredDates = FILTER(ReportingDate, ReportingDate[ReportingDate] = rd || ReportingDate[ReportingDate] = rdM1) RETURN SWITCH(TRUE(), AND(MIN(filteredDates[ReportingDate]) <= MAX(CashFlows[EntryDate]), MAX(CashFlows[EntryDate]) <= MAX(filteredDates[ReportingDate])), "True", "False" )
Please try this measure 🙂
Hi
Thanks for your answer . But i have the below error :
Kinds
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |