Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |