Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

IF in calculated column

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 

fundentrydateNewcolumn

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:

NewCommitment =
var rd = SELECTEDVALUE(ReportingDate[ReportingDate])
var rdM1 = PREVIOUSQUARTER(ReportingDate[ReportingDate])
var entrydate= MAX(CashFlows[EntryDate])

return IF( entrydate < rd && entrydate > rdM1 ,"True","False")

Thanks 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

NewEntryDate =
VAR _CurrentMonth = SELECTEDVALUE(ReportingDate[ReportingDate])
RETURN
CALCULATE(
MAX(CashFlows[EntryDate]),
DATESINPERIOD(
CashFlows[EntryDate],
_CurrentMonth,
-1,
QUARTER
)
)

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

NewEntryDate =
VAR _CurrentMonth = SELECTEDVALUE(ReportingDate[ReportingDate])
RETURN
CALCULATE(
MAX(CashFlows[EntryDate]),
DATESINPERIOD(
CashFlows[EntryDate],
_CurrentMonth,
-1,
QUARTER
)
)
ADPowerBI1
Responsive Resident
Responsive Resident

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 🙂 

Anonymous
Not applicable

Hi 

Thanks for your answer . But i have the below error : 

ndris_0-1674651767657.png

Kinds

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.