Forum Discussion

nps59718's avatar
nps59718
Frequent Visitor
8 years ago
Solved

A function 'CALCULATE' has been used in a True/False expression - Simple Date comparison

Hi There,    I'm looking for a more elegant way sum based on a prior business day calculation.  The following *does work* but will get a little more cumbersome when doing MTD or YTD calculations: ...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    nps59718

     

    Try this one

     

    Prior Day Invoiced =
VAR PreviousBusinessDay = [Priorbusinessday]
RETURN
    CALCULATE (
        SUM ( 'Sales Ledger Transactions'[Net Sales] ),
        'Sales Ledger Transactions'[Fact Attributes.Source Sale Type Code] = "INVOICED",
        'Sales Ledger Transactions'[Date.Date] = PreviousBusinessDay
    )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Worked for hours on this problem before I found this solution. Thank you Zubair_Muhammad !

 

Any help explaining why it wouldn't work without creating the variable? I still don't understand the error fully.

 

rq

Doodle's avatar
Doodle
Icon for Advocate II rankAdvocate II
6 years ago

Same here. 

 

Any elaboration is appreciated.