Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

Need help on DAX function with measure vs column

Hello, Lastest_WorkDate = CALCULATE(MAX(LEM_FACTS[WORKDATE]))-this is measure column NO_OF_DAYS_Running Behind = DATEDIFF(LEM_FACTS[Lastest_WorkDate],TODAY(),DAY)-this is measure column Lev...
Need Help
ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
4 years ago

Thanks its worked.

but something is not working. Total I have 102 contract.  

 

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

I need more info.

Pay attenation that the solution was for a calculated column. Check that the result is correct in the data tab view. You showes a screenshot of a visual which is an aggregation on top of what we did and it depends on the filter context generated by the visual and also on the summarization of the column ( i see count, maybe you wanted sum)

  • ABC11's avatar
    ABC11
    Icon for Resolver I rankResolver I
    4 years ago

    I would like to count (no of vendor(CNRCNSUM)) who fall under those five categary. Total I have 102 CNRCNSUM. 

    This report suppose to show me - each vendor(or contract no) submit their lastest workdate invocie(we call as LEM). So we calculated maximum workdate. then we calculated no of days running behind. and then five categaroy.

    For Business summary - I would like to show how many vendor fall under which categary. 

    Would you help me please

    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      I'm sorry

      I need to see exactly the data, it's already deviated a lot from what I thought was the question. PM me if you want

      vojtechsima any ideas on what is missing from our replies so far?

      • ABC11's avatar
        ABC11
        Icon for Resolver I rankResolver I
        4 years ago

        How can I share my data. How/where I can upload my file PBI file