Forum Discussion

sbarker_11's avatar
sbarker_11
Icon for Helper I rankHelper I
2 years ago
Solved

Multiple date fields for multiple values applied to a slicer

Hi,   I have multiple fields i need to report on, all with their own dates: Application Amount    Application Date Approved Amount    Approved Date Deposit Amount    Deposit Date   I have Unpi...
"Help"
  • sbarker_11's avatar
    sbarker_11
    2 years ago

    I have managed to solve this my self 🙂 simply by creating the below measures for count and sum for EACH attrubute and using them in the table:

     

    DepAmtMeasure =
    CALCULATE (SUM('Export'[Deposit Amount]),
    USERELATIONSHIP('Export'[Deposit Date],'Unpivoted Date Columns'[Date (All)])
    )
     
    DepCountMeasure =
    CALCULATE (COUNTROWS('Export'),
    USERELATIONSHIP('Export'[Deposit Date],'Unpivoted Date Columns'[Date (All)])
    )
     
    then the same for application and approved too. 
sbarker_11's avatar
sbarker_11
Icon for Helper I rankHelper I
2 years ago

I have managed to solve this my self 🙂 simply by creating the below measures for count and sum for EACH attrubute and using them in the table:

 

DepAmtMeasure =
CALCULATE (SUM('Export'[Deposit Amount]),
USERELATIONSHIP('Export'[Deposit Date],'Unpivoted Date Columns'[Date (All)])
)
 
DepCountMeasure =
CALCULATE (COUNTROWS('Export'),
USERELATIONSHIP('Export'[Deposit Date],'Unpivoted Date Columns'[Date (All)])
)
 
then the same for application and approved too.