Forum Discussion

bzeeblitz's avatar
bzeeblitz
Helper IV
1 year ago

Table visuals report

I need to create table visuals report which meets the condition whencreated yesterday and onhand>9months from the below reports   Table Name :cycle;Note:Multiple times Item# found  Item# Ord...
Need Help
Show and Tell
bzeeblitz's avatar
bzeeblitz
Helper IV
1 year ago

 

FilteredDemand = 
FILTER(
    Demand,
    LOWER(Demand[onhand>9 months]) = "more than 9 months onhand"
)

 

im getting cannot find name error onhand>9 months in this line of code LOWER(Demand[onhand>9 months]) = "more than 9 months onhand"

 

ALso im getting error cannot find createdwhen column in

    LOWER(POItem[Createdwhen]) = "po created yesterday"
FilteredPOItem = 
FILTER(
    POItem,
    LOWER(POItem[Createdwhen]) = "po created yesterday"
)

 

 

bzeeblitz's avatar
bzeeblitz
Helper IV
1 year ago

Also createdwhen and Onhand>9 months  is a calculated field ,i mean this below formula is existed in this columns in demand table and poitem table

Onhand>9months = if('Demand'[Months of Available Inventory]>9,"More than 9 months On-Hand","Less than 9 months On-Hand")

CreatedWhen = if('POitem'[Date: Line Created].[Day] = day(TODAY()-1),"PO Created Yesterday","PO Not Created Yesterday")