Forum Discussion

Kevboy_telford's avatar
Kevboy_telford
Frequent Visitor
8 years ago
Solved

Show min date data

I want a user to be able to select a date range and Power BI to show the data for the first date and last date only   I would try using summarize but I need to be able to calculate on the fly....  ...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello you can dim your variable in the formula:

     

    FirstDateCount = 
    VAR EarlieastDate = MIN('Calendar'[Date])
    RETURN
    CALCULATE(DISTINCTCOUNT('Customer_Journey'[customerid]),
    FILTER('JM_Insight Calendar','JM_Insight Calendar'[Date]=[EarliestDate]))

    Are Customer_Journey and JM_Insight Caledar related?

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

Hello you can dim your variable in the formula:

 

FirstDateCount = 
VAR EarlieastDate = MIN('Calendar'[Date])
RETURN
CALCULATE(DISTINCTCOUNT('Customer_Journey'[customerid]),
FILTER('JM_Insight Calendar','JM_Insight Calendar'[Date]=[EarliestDate]))

Are Customer_Journey and JM_Insight Caledar related?

  • Kevboy_telford's avatar
    Kevboy_telford
    Frequent Visitor
    8 years ago

    That is weird - it works when I have it as a VAR within the measure but not when its separate

     

    Thanks for your help!