Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor


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 Initialization = CALCULATE(MIN(DimCalendar[Date]),FILTER(FacSales,FacSales[RUT] = EARLIER(FacSales[RUT])))
So far so good, but now i would like:
  1.  Try to do this expresion but now in a measure.
  2. Due that my report is made with months views, i would like just to see the new clients that appear in the current month. All the dates of the incorporations of the companies are shown, but my intention is only to show the one of the month that I have filtered in the slicer. I don't know very well how to do this since the relationship is between the DimCalendar date and FacSales through the [Fecha_OT] field and not between the "Customer Initialization" field, which is the column I created earlier.

Any recommendation will be well received.


Thak you very much.



Diego V.

Not applicable

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] ),
        MIN( FactSales[Fecha_OT] ),

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.

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?)

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors