Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

ISBLANK in IF

Hi,   I have a measure (""Real_Orders" - connected with Database, future dates do not have a value) and a column ("Target_Orders" for each date in the next 6 months) and I want to subtract them, bu...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    v-jiascu-msft

     

    Thank you for your help.

    I solved it now a different way. I just filtered all future dates an subtract real orders with target orders.

     

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
9 years ago

Depending on how your [Real Orders] measure is created, you may need to test on [Real Orders]=0 instead of BLANK().

 

Hope this helps.

David