Forum Discussion

XaviOV's avatar
XaviOV
Helper V
6 years ago
Solved

Calculated rows by column with random numbers

Hello, I have a column (AñoSemana) with different values, and I want to calculate different values that appear in the different rows of those columns, how can I differentiate between values in the...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi XaviOV ,

     

    Just not clear on your requirement calculation part.

    But if you are looking for extracting unique values from your column, you can use something like this:

    DISTINCT(Table[AñoSemana])

    Replace "Table" above with your table name.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

     

XaviOV's avatar
XaviOV
Helper V
6 years ago

Hi amitchandak and  Pragati11 

The column "AñoSemana" contains the value of YearWeek and what I want to do of the rest of the columns is calculated by each group of "AñoSemana".
For example, in the year 2019 and week 35 I have several different production lines and I want to know which ones are running in these weeks, year 2019 week 36, year 2019 week 35....
I have a column with number of line and other column with the number of these lines.

 

Regards,

 

Xavi

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi XaviOV ,

 

One thing you can do is move your "AñoSemana" on a table visual, try bringing in other columns as summarised (Count, SUM, etc.)

 

You can try looking to few things in Power BI:

https://docs.microsoft.com/en-us/dax/groupby-function-dax

https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax

https://docs.microsoft.com/en-us/dax/earlier-function-dax

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati