power bi calendar tables

2 Topics

Calendar Table returning error: The expression specified in the query is not a valid expression
I am racking my brain. I am building a PBi dash from a SharePoint list. Before, the list had only a few lines of test data, so I had no problem creating the calendar table. However, I have a second data source, and I needed to build a calendar based on both sources' tables to make a splicer to filter visuals by date. At first, I thought the issue was that I had 2 data sources, so I combined them into 1 data source and simplified my DAX Date = CALENDAR( MIN('Deskside QA'[DateofQA]), MAX('Deskside QA'[DateofQA]) ) But after that, I get the error "The start date in Calendar function can not be later than the end date." So I added variables to lock down the functions Date = VAR MinDate = CALCULATE(MIN('Deskside QA'[DateofQA])) VAR MaxDate = CALCULATE(MAX('Deskside QA'[DateofQA])) RETURN IF( ISBLANK(MinDate) || ISBLANK(MaxDate) || MinDate > MaxDate, CALENDAR(TODAY(), TODAY()), // Fallback to a single day calendar if dates are invalid CALENDAR(MinDate, MaxDate) ) But then I get the error "The expression specified in the query is not a valid expression" I have been running in circles and throwing in curly brackets but nothing seems to give me a solution.
Solved
Previsible
1 year ago Place DAX Commands and Tips
Views
1like
Comments
Calendar Table with " Previous YearMonth" and PreviousYearQuarter" included
Hi, I am looking into getting help in building my calender tabel for my dashboard. So, I did start by creating it but I failed to know the syntax for creating a " Previous YearMonth" and PreviousYearQuarter". I currently created a Calender Table from Jan 2017 till Oct 2022 within my fields pane. Can someone help me in providing a syntax for a complete Calender table that includes Date, Month, Year, Quarter, MonthYear, QuarterYear, MonthQuarter, PreviousQuarterYear, PreviousMonthYear, Previous MonthQuarter precisely. Thanks in advance.
Solved
kalkhudary
3 years ago Place DAX Commands and Tips
Views
1like
Comments