Forum Discussion

hgrejsen's avatar
hgrejsen
Frequent Visitor
3 years ago

Issues using IF function for each row = the same values is returned

Hi,   I want to create a pareto grafh for monthly reporting. My plan is that I want to see the past month (Reporting Month) and the privious 3 months before that (In the same color).    My plan w...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi hgrejsen ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

  • hgrejsen's avatar
    hgrejsen
    Frequent Visitor
    3 years ago

    Hi Anonymous,

     

    If I were to do it in normal excel I would do it like this:

     

     

     

    I hope this makes you understand what I want. In my trials in Power BI my IF function does not work when I try to use a prompted parameter but it does work when I just use a constant number. 

     

    Br Helene