date table

Hi, Can someone tell me if Powe pivot and Power Bi work differently in relation to date / Calendar Tables, So if I have a meaure ; SUM(TslaesTable[Sales} ) and I use this in a pivot table which is just has Dates in the Rows, if i use the dates from the sales table I get what I would...

Hi, I've created a date table in power bi, but need to make some alterations in power query, but when I select 'transform' to bring up the power query editor, only the source table for the date table is visible. what am I doing wrong. RD

I am building custom Calendar in PowerBI. For Month number I used the following formula: =dDate[Date].[MonthNo] I got month numbers. After creatin several more collumns I marked the table as a date table and all collumns turned to errors. The error message i got from PowerBI: Column referebce...

Hi, I am working with dates My fields are in order table ...Start date, close date and order no. I have to show open orders in each month I have created relationship with date table by start date I need to show data like If start date is in this month and before this month and end date is this...

Hi experts! I created 4 queries (get&transform) to upload data from some folders. The ETL processes and the schema are perfectly connected and running. I even added steps to change the locale in each column and the format date/time (d/m/yyyy hh:mm:ss) to just date (d/m/yyyy). After I had...

Hi, folks, Is it possible calculating an elapsed time with a predefined date table of working hours? For example: I want know an elapsed time of a process between 01/07/2016 09:00 and 10/07/2016 17:00 using this table: <tbody> Date Start time End time 01/jul 08:00 18:00 02/jul 06:00...

Hey all - this one has been driving me nuts, and I'm sure there's an easy fix to it but I'm not sure what it is - I've set my date tables up per the first table below, but when I link the data table, PowerPivot recognizes the date in a different format. The Excel date table is in the same...

Hello, I recently started watching the amazing ExcelisFun power pivot videos by Mr. Girvin and have been having a blast learning about all of the capabilities and ease of use. I have two questions about the date table that I really need some help with. I've been searching the internet for a...

My fact "sales" table contains transactions between 01/01/2011 and 06/30/2014. My date table contains consecutive dates from year 1998 to 2017. When I use year column from date table in a slicer all the year numbers prior to 2011 and after 2014 are displayed "greyed out" on the slicer. I will...