Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Mapping of Transaction Dates

Hi All,   Can someone please help me to find a solution to map the transaction date using this scenario. Transaction monthly cutoff (21st date Previous month to 20th Current month.   This is what...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous,

 

I can not reproduce your issue without data structure of 'table'.

Could you provide pbix file after removing sensitive information?

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

May i know how can i upload a PBIX file?

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous,

     

    You can save the pbix file to a network drive and then share the public link.

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      I have this code and its working good. May I know your suggestion if I can use  a slicer to change from Normal calendar to SDS calendar?  How can i calculate a certain qty using both option? 

       

      I Put this code under the date table.

       

      Cutoff Month = 

SWITCH(Month(DateTable[Date])
, 12, FORMAT(date(DateTable[Year],MONTH(DateTable[Date]),1),"MMMM") -- & "-" & (DateTable[Year])
, FORMAT(date(DateTable[Year],IF(DAY(DateTable[Date])>=21,MONTH(DateTable[Date])+1,MONTH(DateTable[Date])),1),"MMMM") -- & "-" & (DateTable[Year])
)

       

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous

         

        Sorry, i'm not sure about your expected output, could you provide more details?

         

        Best Regards,

        Link

         

        Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!