I have order table like CustomerId OrderAmount Orderdatetime OrderAmountCurrency AAA 120 02/03/2022 02:03 US$120 AAA 20 02/03/2022 02:20 US$20 AAA 320
I have one query can somebody please tell how to show Latest date in a date format So basically, I want to show the latest date selected by default and if the u
My Sales per Month visual looks like the first part of the picture. To show the running total of transactions I use this Measure: Sum Sales Running Total = C
I have a tableau measure which goes like this: ColumnA= IF [Rating Projection Year 1] = 2021 THEN SUM([Weights Ly]*[Next year rating predicted (1)]*[Inclusion F
I'd like to summarize the following ID's with it's prices on a distinct bases. So that means for the ID 123 both prices get summarize cause they are different.
I have two tables, Table A contains an attribute (ID1) and Time (date/time format). Table B contains an attribute (ID2) and two time columns Time_start and Time
I need help with Power BI. I need to create a meausure to incorporate in the TABLE visualization (which varies according to the filter from the table DATE) so t
I have a table with multiple columns. One of these is 'EAN'. In this column there are supposed to be unique values. Unfortunatly this is not the case. Now I wan
I am creating a calculated column in Power BI using multiple if and Lookupvalue functions, using Lookupvalue function to return "Yes" if SKU exits in Spare SKU
I am not experienced with DAX, but want to create a duration curve in Power BI which is responsive to the user's selections (slicers): I am working with time s
I am trying to calculate the total recipe cost price for each recipe. I used the below DAX formula as shown in the image but I am not getting the correct result
I am doing a DAX query able to retrieve a list of products installed before a certain date (COIDate) , and that have a specific ProductLine. But, it returns t
I am having an issue using the Distinctcount function in DAX. I have a table with a total of 1,154,493 rows. I have a measure created to count the number of d
My test tabe in powerbi: IdRecord Date Value 1 2022-04-25 23:45:00.000 100 1 2022-04-24 18:07:00.000 344 2 2022-05-01 23:45:00.000 5 2 2022-05-02 18:07:00.000
Hi I have two tables(table1 & table2) which both contain year, quarter, month and week. I want to apply a slicer such that when I change the year or Quarter
I have three different tables. I want to select different columns from each of the tables and create one table based on some filters. Have a look at the followi
I have a problem with the MTD column. I want this column to show only April '22 sales and not the previous months. For example, the sales for April '22 is 7379,
My requirement is when a report will be opened in Power BI services by default, the latest date will be selected in a single select slicer. Consider in import m
I have the following problem .. I have this table: I want to create a calculated column that tells me the difference of days between two dates of the same c
I would like to create a YearMonth column in Power BI and group data in this order in visual plot, say histogram. I tried to create a duplicate of the datetime