Forum Discussion

newgirl's avatar
newgirl
Post Patron
1 year ago
Solved

Minimum for ALL

I have this sample dataset: DateIDStep 1Step 2Step 3YearMonth 1/1/2024 1 3 1 1 202401 1/1/2024 2 2 3 1 202401 1/2/2024 3 3 2 1 202401 1/5/2024 4 0 1 2 202401 2/10...
  • Ritaf1983's avatar
    1 year ago

    Hi newgirl 
    Firstly, it is recommended to disable the automatic date hierarchies and create a calendar table that is connected to your transactions table.
    This will allow for much more efficient and flexible work.

    After you have this model you can use the formulas :

    step1_avg = AVERAGE('Table'[Step 1])
    and for minimum months average :
    min_average =
     if([step1_avg]<>BLANK(),CALCULATE(
    Minx(SUMMARIZE(VALUES(caledar[monthYear]),caledar[monthYear],"_x",[step1_avg]),[_x]),ALLSELECTED('caledar')),BLANK())
    Result:

    The pbix is attached

    more information about creating date table here :
    https://iterationinsights.com/article/how-to-create-a-date-table-in-power-bi/

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly