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
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...
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.
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
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...
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
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...
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...
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
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...
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
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...
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