• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Short formula for Multiply and Sum

    Hey Bosco, Really appreciate your help. Thanks again
  2. S

    Short formula for Multiply and Sum

    Hi Guru's I have 2 columns. One column as hourly rate and other column has hours. I want to get the total. Is there a short formula for the data that I have in the attached spreadsheet. I have thousands of row in my actual data. Really appreciate your help. Thanks
  3. S

    Sum based on distinct values of another column

    Thanks Alan. Will give it a try. Really appreciate your help.
  4. S

    Sum based on distinct values of another column

    Sorry to bother you guys, but can anyone take a shot at this problem. Really appreciate all the help
  5. S

    Sum based on distinct values of another column

    Hi, Requesting some help in creating a DAX formula. I have two columns (id and amount). I have duplicate values in id column and as well as duplicate values in amount column. I want to sum the amount column that has distinct values in id column. I have attached a sample file with the desired...
  6. S

    SUM If based on unknown unique values and criteria

    You can use sumproduct SUMPRODUCT(($A$5:$A$8 = A13) * ($C$5:$C$8 = B13),$D$5:$D$8)
  7. S

    vlookup match help

    Another Option using sumproduct =SUMPRODUCT(($B$8:$B$17 = G7) * ($C$8:$C$17 = G8), D8:D17)
  8. S

    DAX Weekday Name using UTC or UTCNOW

    ChiHiro, You method seems to be working. I published the report on Power BI services and it shows the current day and current time. I will let you know what happens after 6:00 PM today. Thanks for your suggestion.
  9. S

    Data Entry Form

    On the data sheet under Birthing just type the Units and the data and excel will automatically create another row and store the data in the table. Please see attached file. Once you enter the data you can sort it. I know very little in VBA
  10. S

    Need help...find Text in the worksheet

    You can use Ctrl + F
  11. S

    DAX Weekday Name using UTC or UTCNOW

    I used this formula to get weekday name and it works in Power BI Deskop. WEEKDAY_TODAY'S DAY = UPPER(FORMAT(TODAY(), "dddd")) When I publish the report on Power BI Services the weekday name changes to the next day at 6:00 PM in the evening. I live in Louisiana Central Time Example: The Power...
  12. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, Awesome. You are a genius. This worked perfectly. I tried for this formula the whole day yesterday. Thanks for your help.
  13. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, I am trying to calculate the YTD values of Last Year based on the Order Date. Example: 01/01/2017 thru 12/20/2017. I have attached updated sample data. Thanks for your help
  14. S

    DAX (Comparison Today vs Last Year Same Day)

    Thanks Chirhiro. That worked. Thanks for your help again.
  15. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, I used your formula: CALCULATE(SUM('Table'[Units Sold]), FILTER('Table',[Month] = FORMAT(TODAY(),"mmm") && [Year] = YEAR(TODAY())-1 && DAY([Order Date] <= DAY(TODAY())))). I get the below result. What am I doing wrong. I see your screen shot and thats the answer I am looking for...
  16. S

    DAX (Comparison Today vs Last Year Same Day)

    I don't have date dimension. I found this online for the Current Year MTD CURRENT_MONTH = IF(YEAR('Table'[order_date]) = YEAR(TODAY()) && MONTH('Table'[order_date]) = MONTH(TODAY()), 1, 0). I used it as a visual level filter in Power BI visual and it worked. Trying to get the Previous Year...
  17. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, I was able to get Month To Date of the current year. How can I get the MTD of Last Year. Its the same Data Set. Please ignore the Fields in the screenshot Thanks for your help
  18. S

    DAX (Comparison Today vs Last Year Same Day)

    That worked. Thanks for your help
  19. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, This is what I am getting when I used the Current Day Sales formula. Also your screen shot shows Current Sales at 770 for 12/17/2018. But I get a total of $1650 for 12/17/2018. My data set is in excel for now and I dont have any sales for the Gonzales Plant. Not sure why Power BI is...
  20. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, The Current Day Sales formula didnt extract any values. Thanks
  21. S

    DAX (Comparison Today vs Last Year Same Day)

    Chihiro, Thanks for your quick response. I will give it a try. I am doing a direct query from a SQL Server database and not sure if I can create a dimension table. Thanks for your help
  22. S

    DAX (Comparison Today vs Last Year Same Day)

    These are the fields in my Data Set. I am trying to avoid filters on the report. I have attached a small sample data set Order Date Year Month Units Sold 1. I want to extract Units Sold as of today (Current Day) based on the Order Date 2. I want to extract Units Sold as of same day (Last...
  23. S

    YTD Sumifs based on Dates

    Thanks GraH. What does this mean ("1/"&AB$3) in the formula. Thanks
  24. S

    YTD Sumifs based on Dates

    Thanks Bosco. Works perfectly as always
  25. S

    YTD Sumifs based on Dates

    GraH, Can you include the Month in the formula. I would like to show YTD values at a particular month. So when I change the month name in both YTD say MAR for both years, I should get values as of March for both years which should include values JAN to MAR. Thanks
Back
Top