The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, with my first question here I had bitten of a lot more that I could chew, so today I am asking about a smaller step in my DAX learning process.
I try to calculate a First Order Date from an Invoices table.
This is my calendar DAX:
DateTable = ADDCOLUMNS(CALENDARAUTO(), "MonthNo", MONTH([Date]), "MonthName", FORMAT([Date],"MMMM"), "Quarter", QUARTER([Date]),
"Year", YEAR([Date]), "Day", DAY([Date]), "WeekdayNum", WEEKDAY([Date]), "WeekdayName",FORMAT([Date],"DDDD"), "YearMonth", FORMAT([Date], "YYYY-MM"), "YearQuarter", FORMAT([Date], "YYYY-Q"))
So far, I have tried a few variations. At the moment, I have tried this code:
FirstOrderDate = CALCULATE(MIN('invoices_2019-2022'[Date Initiated]), ALL(DateTable[Date]))
That works fine as long as I have not selected any quarter in the slicer.
Yet, as soon as I select a YearQuarter, the results change, and I get the First Order Date in the context of the slicer, despite the ALL function.
Before, I had tried this:
FirstOrderDate = CALCULATE(MIN('invoices_2019-2022'[Date Initiated]), REMOVEFILTERS(DateTable[Date]))
Same result.
As you can probably tell, I have about a 5-year-old's underdstanding of DAX, so please explain in a simple way.
Thanks a lot.
Solved! Go to Solution.
Looks like the solution was pretty simple - I need to use REMOVEFILTERS on the whole table, not just the [Date] column:
That did the trick.
Looks like the solution was pretty simple - I need to use REMOVEFILTERS on the whole table, not just the [Date] column:
That did the trick.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |