Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
6 years ago
Solved

Help on DAX

Hi guys,   Need some help on my visualisation. I have this data which is an Item List, with its invoice date then a "age" time between that invoice data and my input date (lets call it As Of Date) ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    The AND() function takes 2 inputs.  Only when both inputs evaluate to TRUE will the AND() function also evaluate to TRUE. So if the Age of the invoice is >= min value and also <= max value, then it means that the Age of invoice falls between the min and ma values.  The AND() function will therefore evaluate to TRUE.  To convert TRUE to 1, one can multiply with 1.

    Hope this clarifies.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi!

You can simplified this by creating a calculated column in your "items" table.

Create the calculated column with the next dax formula in your "items" table: 

INTERVAL = IF(ITEMS[Invoice age]>=0,IF(ITEMS[Invoice age]<=30,"<= 30 days",IF(ITEMS[Invoice age]<=90,"31 - 90 days","> 90 days")))
With this you can create the matrix you want:
 
 
  • admin_xlsior's avatar
    admin_xlsior
    Post Prodigy
    6 years ago

    Hi, 

    Sorry, I forgot to tell, I also need the range to be from a table. And what I know is I need to use CALCULATE to do that, however there is another stopper, I cannot use CALCULATE since I'm using Direct Query.

     

    So that is the background story why I create a measure. (CALCULATE is not allowed for CalculatedColumn)

     

    Thanks,