diff options
Diffstat (limited to 'tests/examplefiles/dax/dax_example1.dax')
| -rw-r--r-- | tests/examplefiles/dax/dax_example1.dax | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/tests/examplefiles/dax/dax_example1.dax b/tests/examplefiles/dax/dax_example1.dax new file mode 100644 index 00000000..39b48891 --- /dev/null +++ b/tests/examplefiles/dax/dax_example1.dax @@ -0,0 +1,11 @@ +/* This calculation sums sales divided +by days in the month +multiplied by current MTD +*/ +Total Sales Spread = ( + --This line does a calculate + CALCULATE ( + SUM ( TABLE1[SALES]), + PBCS_PLAN_FCST[Scenario] = "Plan" + ) / 'Days in Month'[Days in Month Value] +) * 'Current MTD'[Current MTD Value]
\ No newline at end of file |