Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Question regarding DAX Patterns -

Hello Community  -  I am utilizing the DAX patterns formulas at this link.    Their example follows a specific column (order date).   

 

However, I have three such dates I would like to create time intelligence formulas for.   Order Date is one of them, but also Ship Date, and Due Date.   Due Date comes from the Orders table (just as Order Date does).     Ship Date comes from our Shipping Table.    Of course I will need to connect these to my date table, which I have done already.  

 

But my question is really around this formula below.   This formula is specifically for the Order Date, but I need this same formula applied to all three date fields.   I was hoping not to have to create three seperate  measures.   Is there a way to combine those three date fields into this formula?    For example, if I want to create a YTD measure for Orders (based on Order Date, and another measure for shipments YTD (based on ship date), I'd like to just be able to reference the same "showvaluefordates" measure in both YTD formulas.   Possible, or do I need to create, and reference, three distinct measures for each scenario? 

 

Standard time-related calculations – DAX Patterns

 

ShowValueForDates :=
VAR LastDateWithData =
    CALCULATE (
        MAX ( 'Sales'[Order Date] ),
        REMOVEFILTERS ()
    )
VAR FirstDateVisible =
    MIN ( 'Date'[Date] )
VAR Result =
    FirstDateVisible <= LastDateWithData
RETURN
    Result