-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
powerbi
-
E
Is Today =True - Date column wrong Power Query code.
Hi All, I have a powerquery script to create my date table. Think I copied it from powerpivotpro.com (great site) Has been working ok but I just realised that the IsToday column is wrong. Right now it is Wednesday the 9th of September but it thinks today is Tuesday the 9th of September...- elliotstan
- Thread
- dates istoday powerbi powerquery
- Replies: 4
- Forum: Power Tools
-
C
Time Diagram in Excel PowerPivot or PowerBI
Hi I have products which are reserved during some days. The data are Productname, FromDate, ToDate. I have to display these data in a diagramm, the products ins rows and on then on the right side each date as column and an bar which goes from FromDate to ToDate (like in Microsoft Project). In...- chmav
- Thread
- excel power pivot powerbi
- Replies: 0
- Forum: Power Tools
-
L
Previous month to date DAX syntax
Hi all, I am trying to build a formula to compare MonthToDate (MTD) and Last month todate (LMTD) values. MTD is easy enough, however its the last month's calculation that i cannot get. If today is 14-March, and my KPI ("myExpression") for the month to-date is currently at, say 250, I want to...- lochem
- Thread
- dax powerbi powerpivot time functions
- Replies: 10
- Forum: Power Tools
