Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Simplify the code

Hey,    Would you have an idea to simplify my dax calcul ?      I want to do this for a month, so it's more complicated.
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Perhaps use MONTH and YEAR to get the month and year of your [Date] and then use a CALCULATE(SUM where the month and year of the [Date] equals those values? Hard to determine what exactly you are trying to do.

 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi, thanks for your answer.

     

    The fact is that i need to do a weighted average on a month, (like what i did for the week). As you can see the second variable [Nombre de sessions cumulées par semaine] isn't affected by the date (dateadd). 

     

    To simplify i want to do exactely the same thing you can see on the screen with only function if it does exist. 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      4 years ago

      Anonymous Again, not following. First, I don't see any variables (VAR statements) in your code. And where the weighted average comes into play is not clear. I would have never guessed that was a weighted average formula. Without example data and expected output, it's hard to tell you what you need to do.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Greg_Deckler 

        I'll give you an example of what i actually want on excel. 

        There is the context : 

        I want to calculate the cumulative average time by session for the day 5 for example. 

         

        So I start by calculating each day, depending on the number of session, the average time by session and the cumulative session which is the sum of all the sessions. 

        Then to have my result i need to sum all of them, 

         

        I want to do the same on power bi on a month period for each day. 

        Example : if i choose the 1st February, i want the cumulative average time by session from 1st January to 1st February. 

         

        Sorry if i'm not clear enough, my english isn't the best. 

         

        Thanks for your answers.