Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Calculation with multiple rules

Hi there, I am looking create a measure "Quote Waiting Customer Review" with multiple rules. The rules are below. CANCELLED is a date field. INVOICED is a date field. LGI_MAINTENANCE is a date...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Anonymous did you copy and paste my code into your PBIX and just change the table name from 'Table' to whatever your table is called?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Theo

I understand that but even when i do this, the field [CANCELLED] ETC is greyed out and cant be select. I have checked that those fields are in the same table as where i am creating the meausre. Its actually not picking up the Field when typing the DAX

 

 

TheoC's avatar
TheoC
Community Champion
4 years ago

Anonymous my apologies, the screenshot has helped my understanding of the problem.  

 

If you were to delete the measure, then re-write it from scratch (instead of copying and pasting), are you able to see columns / fields after the Table name?  For example, if you type 'AR_MANAGER BI_DASHBOARD_SRC_VW' does it give you any columns/fields after it as options to select?