Forum Discussion

shiva_gri's avatar
shiva_gri
Frequent Visitor
9 years ago

Display Week end (Friday) or Month End results based on filter selected

Hi, I am new to Power BI. I have Year, Quarter, Month and Week Numbers (W1,W2,W3..) Filters. Need to sum Revenue for each Candidates and display in Table chart based on below conditions. The table h...
Need Help
AlbertBISM's avatar
AlbertBISM
Icon for Advocate I rankAdvocate I
9 years ago

There is a function called ENDOFTHEMONTH, ENDOFTHEQUARTER to achieve this.

  • shiva_gri's avatar
    shiva_gri
    Frequent Visitor
    9 years ago

    Thanks. I already have the end of quarter or month calculated on another table and a flag says it is month end or quarter end or weekend. The data looks like this.

     

    Agent        Revenue     Date                      Isweekend  Ismonthend IsQuarteend

    A                 10             31-Aug-2016                N             Y                      N

    B                 20              26-Aug-2016                Y              N                    N

    A                 20             19-Aug-2016                Y                N                   N

     

    I have filters Year, Month name, Week. When I select month name (August) in filter it lists all revenue for Aug (3 records). I need to list only 31-Aug-2016 (first record). What DAX formula should be used in measure to get only last day of the month record based on IsMonthEnd = Y