Forum Discussion

CJDK's avatar
CJDK
Helper II
5 years ago
Solved

Cannot get quarterly difference matrix to work

I am trying to build a matrix that compares the differences from one quarter to another - actual differences or percentage differences.   I have tried copying several examples without success. The ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    CJDK , with help from date table marked as date table , these should work 

    Supports LQ = CALCULATE(COUNT(MyTable[Support type]),DATEADD('Date'[Date]-1,QUARTER))
Supports LQ = CALCULATE(COUNT(MyTable[Support type]),datesqtd(DATEADD('Date'[Date]-1,QUARTER)))

     

    Make sure the date table is marked as a date table, there is no timestamp in the fact/table table

     

    refer

    Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

amitchandak's avatar
amitchandak
Super User
5 years ago

CJDK , with help from date table marked as date table , these should work 

Supports LQ = CALCULATE(COUNT(MyTable[Support type]),DATEADD('Date'[Date]-1,QUARTER))
Supports LQ = CALCULATE(COUNT(MyTable[Support type]),datesqtd(DATEADD('Date'[Date]-1,QUARTER)))

 

Make sure the date table is marked as a date table, there is no timestamp in the fact/table table

 

refer

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw