Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Changing Time Dimension changes the data presentation incorrectly.

Hi, I have a project status table and a date table and I am looking for the active projects between two dates.  The measure works fine if I just use the date hierachy but I want it to show is a year...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , if you have already joined your date of the table with the date of calendar, then you do not need to use min and max to force the range

    This should work

    Calculate(DISTINCTCOUNT(vwJiraDistributionByQuarter_MODEL[IssueKey])

     

    if needed add filter

     

    Flows On Date =
    VAR MAXDate=MAX(vwFiscalCalendar[CalendarDate])
    VAR MINDate= MIN(vwFiscalCalendar[CalendarDate])
    Return
    Calculate(DISTINCTCOUNT(vwJiraDistributionByQuarter_MODEL[IssueKey]),
    filter( vwJiraDistributionByQuarter_MODEL , vwJiraDistributionByQuarter_MODEL[CreatedOn]>=MINDate,
    vwJiraDistributionByQuarter_MODEL[CreatedOnNext]<=MAXDate)
    )

     

     

    Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
    https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , if you have already joined your date of the table with the date of calendar, then you do not need to use min and max to force the range

This should work

Calculate(DISTINCTCOUNT(vwJiraDistributionByQuarter_MODEL[IssueKey])

 

if needed add filter

 

Flows On Date =
VAR MAXDate=MAX(vwFiscalCalendar[CalendarDate])
VAR MINDate= MIN(vwFiscalCalendar[CalendarDate])
Return
Calculate(DISTINCTCOUNT(vwJiraDistributionByQuarter_MODEL[IssueKey]),
filter( vwJiraDistributionByQuarter_MODEL , vwJiraDistributionByQuarter_MODEL[CreatedOn]>=MINDate,
vwJiraDistributionByQuarter_MODEL[CreatedOnNext]<=MAXDate)
)

 

 

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4