Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help doing some calculations on the data

Good Day.   I am pretty new to PowerBI/DAX. Need expert advise to help me achive below objectives.   1. Rolling/cumulative sum for the facts by day, province/state, country/region 2. How to calc...
  • Don_Alexis's avatar
    5 years ago

    Hello

    You can translate monthly and/or all in a single graph depends on the communication and analysis intension of your previous audience.

    to solve the first question uses a quick mean according to what will be counted in this case choose PROVINCE / STATE add it to a line chart and to perform the quick measurement, right click, the last option

    Nueva medida rapidaNew quick measure

    loads a screen and we will search in totals, cumulative total elegir total acumulado choose total accumulated Totalacumulado Total accumulated

    We agree and the measure is lowered/moved/moved/changed as SECONDARY VALUES, as such you will have the graph of the journal and the accumulated one with an axis of DAYS.

    el acumulado lo pones como 2do valorthe accumulated you put it as 2nd value

    for a better visualization a segmentation of data with the date/month.

    Ss.