Forum Discussion

SethuPower's avatar
SethuPower
Frequent Visitor
7 years ago
Solved

Increase Count on Status & Product Change

Hello All,

Product and Status is the columns i have and need data in column Group as output.

Group number to change when the status changes and Product changes

Could you please help with the DAX query

Ashish_Mathur - I could see you have helped on similar query. Could you please assist on this one

 

ProductStatusGroup
SoapApproved1
SoapApproved1
SoapRemoved2
SoapRemoved2
SoapSales3
SoapRemoved4
SoapOthers5
SoapRemoved6
SoapRemoved6
SoapRemoved6
SoapRemoved6
SoapRemoved6
SoapOthers7
SoapOthers7
SoapOthers7
BoxApproved1
BoxRemoved2
BoxRemoved2
BoxOthers3
BoxSales4
BoxSales4
Counter

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    Could you share the link of the post where you saw my solution to a similar problem.

    • SethuPower's avatar
      SethuPower
      Frequent Visitor
      7 years ago

      hi Ashish,

       

      Thanks for your reply. Unfortuantely couldn't find that post now. Any luck based on the data example?

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Icon for Community Champion rankCommunity Champion
        7 years ago

        SethuPower 

         

        Try this

         

        let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCs5PLFDSUXIsKCjKL0tNUYrVwSsWlJpLhFBwYk5qMQE1/iUZqUWEFFFTCNNCvCJO+RXoYQARQjYalwiGOYgQQeHHAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Product = _t, Status = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Product", type text}, {"Status", type text}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Product"}, {{"ALL", each _, type table }}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn(
Table.Group([ALL], {"Status","Product"}, {{"ALL", each _, type table }},GroupKind.Local),"Index",1,1)),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"ALL"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Status", "ALL", "Index"}, {"Status", "ALL", "Index"}),
    #"Expanded ALL" = Table.ExpandTableColumn(#"Expanded Custom", "ALL", {"Status"}, {"Status.1"})
in
    #"Expanded ALL"