Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
6 years ago
Solved

Static Time Intelligence

I need to put static point in time reporting (time intelligence) measures in a dashboard or a table, i,e. they are not based on filter selection. The screenshot below from another BI tool i am migrat...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Another way is create Rank on Year, Qtr and Month and use that to find current prior

     

    QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),Filter(all(QTR),QTR[Rank]=Max(QTR[Rank]))
    Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),Filter(all(QTR),QTR[Rank]=Max(QTR[Rank])-1)

     

    Year can work without rank.

     

    Refer, this week example

    https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0

parry2k's avatar
parry2k
Super User
6 years ago

Chitemerere wow there is a lot reading. seems like these are basi time intelligence calculations and there are tons of blog posts on it. Did you checked /research on what is already available and then can you come back with specific queston where you couldn't find the solution. 

  • Chitemerere's avatar
    Chitemerere
    Responsive Resident
    6 years ago

    Thank you very much for your prompt response.  What i am presenting here i dont think is available in Power BI.  I have given specific examples i have been using in QlikView.  Below is a Power BI example:

     

     

    This example has a date column which is different from what i presented using another BI tool, it does use a date columin

     

    Regards,

    Chris