Forum Discussion

ammar_cs_2004's avatar
ammar_cs_2004
Frequent Visitor
3 years ago

Determine whether A Date is In-between Two Dates in Power BI

Hi everyone, I have two tables.The first one is for Asset History The second one is for items Issue for Asset I want the to do add new column to the second table to bring To Code   First Table (A...
Need Help
ReneMoawad's avatar
ReneMoawad
Icon for Resolver III rankResolver III
3 years ago

Hello ammar_cs_2004,

 

Try the below:

 

To Code =
VAR _occurrenceDate = 'Stock Ledger'[Vr. Date]
VAR _occurrenceCode = 'Stock Ledger'[Asset Code]
RETURN

CALCULATE(
    FIRSTNONBLANK('Asset Transaction'[To Code], 1)

    , _occurrenceCode == 'Asset Transaction'[Asset Code]

    , _occurrenceCode <> BLANK()

    , _occurrenceDate >= 'Asset Transaction'[Start Date]

    && _occurrenceDate <= 'Asset Transaction'[End Date]

)

  • ammar_cs_2004's avatar
    ammar_cs_2004
    Frequent Visitor
    3 years ago

    thanks for reply but it is not working have error 

    (The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.)