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

Hi Theo,

Thanks for your reply.

'Table'[Cancelled] 'Table'[Invoiced] etc, are all dates in the same table.

How when i write the DAX i cant seem to select or find the these fields?

Thanks

TheoC's avatar
TheoC
Community Champion
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

    Yeah I did

    • TheoC's avatar
      TheoC
      Community Champion
      4 years ago

      Anonymous can you screen shot what the measure you used?

      • TheoC's avatar
        TheoC
        Community Champion
        4 years ago

        Anonymous I am not sure how to reopen a post, but I promise I will work with you until it's resolved 🙂