Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with Count

Hi Everyone, I am new to Power BI and I have a count problem. In the table below, I am trying to create an analysis of how the delivery days of the following products have changed from Jan - May. Th...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Is this how your data are structured (with Months as columns)?  If so, the data should be unpivoted in the query editor.  Once that is done, a measure can be written that give the count of products that have >1 values of Delivery Days.

 

Regards,

Pat

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pat,

Thanks for the message. The data is not structured as months in column. I only included it in the table to show how the delivery days changes during the month.  If we are to ignore the months column, how can I count the products that have > 1 values of delivery days. Thank you.