Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So i have this DAX here and I want to be selecting current Quarter automatically instead of manually changing it every time what should I change?
Solved! Go to Solution.
@CharlesMS Try:
Target =
VAR __Quarter = "Q" & QUARTER(TODAY())
VAR __Result =
Calculate(SUM('TABLE'[Budget])/12, FILTER( TABLE,'TABLE'[Year]=2018 && 'TABLE'[Quarter]=__Quarter))
RETURN
__Result
@CharlesMS Try:
Target =
VAR __Quarter = "Q" & QUARTER(TODAY())
VAR __Result =
Calculate(SUM('TABLE'[Budget])/12, FILTER( TABLE,'TABLE'[Year]=2018 && 'TABLE'[Quarter]=__Quarter))
RETURN
__Result
I get the following error when I use this now:
MdxScript(Model) (1427,67) Calculation error in measure 'Table'[Measure]: DAX comparison operations do not support comparing value of type Text with value of type integer.
Consider using the Value or format function to convert one of the values.
So my measure is :
The column Year is dax like this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |