Forum Discussion

Dvilches_'s avatar
Dvilches_
Frequent Visitor
5 years ago

EARLIER FUNCTION

Hello everyone,   I hope you're doing great. I made a column calculation (in FacSales table) that identifies in wich date a company started working with us trough this expresion:    Customer Ini...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

You should never, ever create a calculated column in a fact table using CALCULATE unless the fact table is really tiny. On real fact tables it's going to take a lot of time to calculate. Very often it just leads to a crash due do the amount of memory needed.

 

[Cust Init Date] =
IF( HASONEVALUE( DimCustomer[CustomerID] ),
    CALCULATE(
        MIN( FactSales[Fecha_OT] ),
        ALLEXCEPT(
            FactSales,
            DimCustomer
        )
    )
)
  • Dvilches_'s avatar
    Dvilches_
    Frequent Visitor
    5 years ago

    Thanks for the feedback daxer, i got same result. Now how can i get just dates depending on selected value in slicer? (Using something like ALLSELECTED?)

  • Dvilches_'s avatar
    Dvilches_
    Frequent Visitor
    5 years ago

    Daxer, i think that i found the way using another measuere that uses your recomended measure:

     

    Measure = CALCULATE([Cust Init Date], FILTER(FacSales, MONTH(FacSales[Fecha_OT]) = MONTH([Cust Init Date])))
     
    So thank you again.